If this is beyone Excel's scope to do this, I would appreciate someone saying
so...

"GLT" wrote:

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