Linking Excel Worksheets
Hi Roger,
Thanks for your reply.
One thing a forgot to note was that the data in sheets B, C, D and E are
filtered.
When I use this method, the data typed into worksheet A appears on the other
sheets regardless of the filter.
Is there anyway that for the Data in worksheets B, C, D, E be obtained from
A, but the filters apply when the B, C, D and E are selected?
Cheers
"Roger Govier" wrote:
Hi
Click on tab A, hold down Shift and click on tab E
The sheets are now Grouped and at the top left of your screen you will see
[Grouped].
Now anything you do to any sheet will be reflected in all of the others.
Just click on any individual tab to Ungroup them.
Regards
Roger Govier
GLT wrote:
Hi,
I have 5 worksheets set up - A, B, C, D and E.
I would like to have worksheets B, C, D and E so that they are a copy of A.
Whenever there is a change made to worksheet A (Something is added, or
deleted or modified) then this is reflected on the other worksheets.
Is there anyway to link worksheets this way (not just particular cells)?
|