+ Reply to Thread
Results 1 to 3 of 3

How do I save autofilter data

  1. #1
    jbwerner
    Guest

    How do I save autofilter data

    I have a spreadsheet that uses autofilters. I want to apply some filters and
    save the Excel spreadsheet with a different name and remove the autofilter.
    I know I could cut and paste the data, but I'm looking for a better way.

  2. #2
    Nick Hodge
    Guest

    Re: How do I save autofilter data

    Without code there is not a way of moving the data, you might consider
    Advanced filter which will move the data to another part of the sheet, you
    can then delete the original data and save as a new file (not sure that's
    much shorter).

    Have you considered using Custom views? This allows you to save various
    filter settings and simply select the view to change the filter. This way
    you may only need one file.

    (View>custom views...)

    Otherwise, I suspect you will need code

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

    "jbwerner" <jbwerner@discussions.microsoft.com> wrote in message
    news:22C9DA73-A5ED-4716-B038-245F80EF8D05@microsoft.com...
    >I have a spreadsheet that uses autofilters. I want to apply some filters
    >and
    > save the Excel spreadsheet with a different name and remove the
    > autofilter.
    > I know I could cut and paste the data, but I'm looking for a better way.




  3. #3
    Ron de Bruin
    Guest

    Re: How do I save autofilter data

    Hi jbwerner

    Maybe you like this Add-in
    http://www.rondebruin.nl/easyfilter.htm

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "jbwerner" <jbwerner@discussions.microsoft.com> wrote in message news:22C9DA73-A5ED-4716-B038-245F80EF8D05@microsoft.com...
    >I have a spreadsheet that uses autofilters. I want to apply some filters and
    > save the Excel spreadsheet with a different name and remove the autofilter.
    > I know I could cut and paste the data, but I'm looking for a better way.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1