General Setup!!

[Rich]

Hello

I have a large Master Worksheet with an Autofilter set on
it. I mainly only filter one column of data. In this
column there are only three different types of data. Once
I have applied the filter for one of these I would like
this data (along with its other columns) to be put into
another worksheet but in the same Workbook. In the end I
want one Workbook with the master Worksheet and three
other Sub-Worksheets with the filtered data. This isn't
the problem!! Once this has been setup I want to be able
to ammend the Master Worksheet so that the other Sub-
Worksheets updated automatically also.

Is this possible? If so, how?

Thanks

Rich

 

[Debra Dalgleish]

If you filter the data, and copy it to a different sheet, it won't be
linked to the master sheet. Any changes you make to the master data
won't be reflected in the copies.

You could maintain the master sheet, and create a macro to filter to the
sub-sheets when required.