Without more to go on i can only give you a general idea, put this in
the Master worksheet code module


Code:
--------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Value
Case "Entity A"
Target.EntireRow.Copy Destination:=Sheets("Entity A").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Case "Entity B"
Target.EntireRow.Copy Destination:=Sheets("Entity B").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Case "Entity C"
Target.EntireRow.Copy Destination:=Sheets("Entity C").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Select
End Sub
--------------------


Susan S;397806 Wrote:
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.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111072