Custom filter setting
 

Is it possible to configure a custom filter setting that has been applied to
one worksheet to run on several other identically-formatted worksheets within
the same workbook such that it mirrors this filtering on each of these
worksheets?

Custom filter setting
 

Zakynthos,
You can write VBA code to custom filter a sheet. You then simply run the
code again for the different sheet or program the code to run on all sheets.
I have written code to custom filter a table of data before.

Is this what you are refering to?
Aran Black


"Zakynthos" wrote:

Is it possible to configure a custom filter setting that has been applied to
one worksheet to run on several other identically-formatted worksheets within
the same workbook such that it mirrors this filtering on each of these
worksheets?

Custom filter setting
 

Aran,

Yes, many thanks - this did occur to me AFTER I posted the question and yes,
your idea works fine - again, many thanks for your advice.

Tony

"Aran Black" wrote:

Zakynthos,
You can write VBA code to custom filter a sheet. You then simply run the
code again for the different sheet or program the code to run on all sheets.
I have written code to custom filter a table of data before.

Is this what you are refering to?
Aran Black


"Zakynthos" wrote:

Is it possible to configure a custom filter setting that has been applied to
one worksheet to run on several other identically-formatted worksheets within
the same workbook such that it mirrors this filtering on each of these
worksheets?