Linking Excel Worksheets
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)?
|