Hi,

You may want to refer to refer to Question 7 of
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Susan S" wrote in message
...
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!
--
Susan S.