Automatically copy from Master worksheet to others

  • Thread starter Thread starter Susan S
  • Start date Start date
S

Susan S

I am new to Excel, so please pardon my low level of comprehension.

I have a large workbook with 4 worksheets (master, Entity A, Entity B and
Entity C), which tracks stock ownership by the three different entities. I
am trying to find out if it's possible to set up some sort of condition where
any entry made in the Master worksheet containing "Entity A" automatically
copies to the Entity A worksheet, etc. I can't link specific cells because I
have no clue what cells will pertain to which entity.

Any ideas/suggestions are welcomed - even if it's to say no, you can't do
that.

Thanks much!
 
Thank you for your response, Simon. Hate to admit this, but I don't know
what the "Master worksheet code module" is, so I can't try your suggestion to
see if it works! I have been searching for training, etc., online, but so
far I'm mostly finding training for things I do know or won't use.

Sorry if I'm being hopelessly slow. I really DO appreciate the help!
 
Try this sample from my archives, a non-array formulas solution:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key column.

In your case, that key column will be where you have the Entity A, Entity B,
etc
Celebrate your success, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top