PC Review


Reply
Thread Tools Rate Thread

Custom filter setting

 
 
=?Utf-8?B?WmFreW50aG9z?=
Guest
Posts: n/a
 
      31st Oct 2007
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 With Quote
 
 
 
 
=?Utf-8?B?QXJhbiBCbGFjaw==?=
Guest
Posts: n/a
 
      31st Oct 2007
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 With Quote
 
=?Utf-8?B?WmFreW50aG9z?=
Guest
Posts: n/a
 
      1st Nov 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto filter custom filter stevefromnaki Microsoft Excel Worksheet Functions 2 30th Dec 2009 06:23 AM
setting default filter setting tpeter Microsoft Excel Charting 0 4th Dec 2009 02:50 PM
Re: Code for setting Forms to open with custom tool bar, menubar and control custom short Rick Brandt Microsoft Access 0 5th Feb 2006 01:06 PM
Accessing/Setting Custom Properties in a Custom TreeNode Bishop Microsoft VB .NET 0 29th Sep 2005 03:12 AM
Custom Auto Filter default setting should be contains =?Utf-8?B?ZG1j?= Microsoft Excel Worksheet Functions 0 14th Jun 2005 07:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:16 PM.