View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default 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)?