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