Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter custom filter | Excel Worksheet Functions | |||
setting default filter setting | Charts and Charting in Excel | |||
Filter setting | Excel Worksheet Functions | |||
Setting custom Tab order | Setting up and Configuration of Excel | |||
Custom Auto Filter default setting should be contains | Excel Worksheet Functions |