Saving Auto Filter Combinations.

[jonnykyte]

Hi,

I just wondered if anyone knew a way to save various auto filter
combinations in excel to allow easy access to a set of results. It
would be useful if I could keep a complete list in an excel workbook
and quickly amend the searches to highlight a subset of results.

At the moment I'm having to use multiple workbooks which is leading to
duplicate data.

Regards

 

[Ardus Petus]

What you need requests some VBA code.
Interested?

Cheers,

 

[jonnykyte]

The only catch is that my VBA is extremely limited. If anyone had any
pointers/links or even code, I would be extremely grateful.

 

[David McRitchie]

Finding the actual question is always a problem whenever anyone tries
to put the question into the subject line rather than into the text body.

In the meantime try this site:
http://www.contextures.com/tiptech.html

 

[Debra Dalgleish]

Another option is to use Custom Views, which can store filter settings.
There are instructions in Excel's Help.