Results 1 to 3 of 3

Thread: Saving filters

  1. #1
    New Lounger
    Join Date
    Feb 2009
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way to save filters in MS Excel 2003?

    I regularly run a report and I would like to apply about 7 filters to it so that I can save these results in my report.

    Each time I apply the Data -> Filter -> AutoFilter I have to redefine all 7 filters.

    It would be great if I can just add my 7 separate filter criterias to a toolbar.

    Can I do this without programming in VBA?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sure. Use custom views.
    1. Setup your filter
    2. Click View tab, Click Custom views on the workbook views group
    3. Click Add and enter a name such as Filtered, click OK.
    4. remove filters and repeat 2 and 3.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Feb 2009
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Jan. It works perfectly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •