Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto filter custom filter stevefromnaki Excel Worksheet Functions 2 December 30th 09 06:23 AM
setting default filter setting tpeter Charts and Charting in Excel 0 December 4th 09 02:50 PM
Filter setting dNd BdN Excel Worksheet Functions 3 September 5th 07 02:29 PM
Setting custom Tab order Rusty Setting up and Configuration of Excel 2 May 17th 07 06:43 PM
Custom Auto Filter default setting should be contains dmc Excel Worksheet Functions 0 June 14th 05 07:54 AM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"