Gord,
That makes sense. I'll check out the website. Thanks for your help!
Jen


"Gord Dibben" wrote:

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


On Fri, 8 Sep 2006 08:50:02 -0700, Jen wrote:

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!