Hi

If you re-apply the filter on the sheet, by clicking the drop down and
re-selecting the original selection, this will "clean up" the sheet form any
extraneous values that get carried over to it.

If you wanted to automate this, put the following code into each of sheets
B,C,D,E

Private Sub Worksheet_Activate()

Selection.AutoFilter Field:=1, Criteria1:="Roger"

End Sub

Change the criteria on each one to the selection criteria you want.

Right click on the sheet tabView Code and paste the code into the top right
pane.

Regards

Roger Govier


GLT wrote:
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)?