auto copying

J

Jen

How do I automatically copy cells from the master worksheet to various
worksheets when line 1 goes to worksheet A, line 2 goes worksheet B etc? Is
there a formula for this?
Thanks for your help!
 
G

Gord Dibben

Jen

Formulas can only "pull" data from sources.

They cannot "push" data to targets.

Can you look at using linking formulas on the various sheets that pull from the
master worksheet?

Otherwise you will need to use VBA

A good resource for code is Ron deBruin's site.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP
 
Top