Automatically copy from Master worksheet to others
 

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.

Automatically copy from Master worksheet to others
 

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

Automatically copy from Master worksheet to others
 

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!
--
Susan S.


"Simon Lloyd" wrote:


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

Automatically copy from Master worksheet to others
 

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
---

Automatically copy from Master worksheet to others
 

*How to Save a Worksheet Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on the *Worksheet's Name Tab*
for the Worksheet the macro will run on.
3. *Left Click* on *View Code* in the pop up menu.
4. *Paste* the macro code using *CTRL+V*
5. Make any custom changes to the macro if needed at this time.
6. *Save* the macro in your Workbook using *CTRL+S*

I will try to help you through it as much as possible, Max' suggestion
looks good :)

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


"Simon Lloyd" wrote:


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'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Automatically copy from Master worksheet to others
- The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=111072)




--
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

Automatically copy from Master worksheet to others
 

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.