Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Auto Filter

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    139
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a larg amount of data that at times need to use the Auto Filter to get to certen sets of information. However it can take up to five minutes get the process through. Is there a way to speedy up the process, while still using the Auto Filter?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    not that i know of with autofilter have you got a lot of formulas?

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    139
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes... I have many formulas. If there is another way of doing it other then using AutoFilters. I will be happy to try new things

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if it takes 5 minutes, I'd be tempted to "copy / paste / special values" the whole sheet to a temporary sheet, then apply your normal filtering, unless you want any formulae and formatting preserved


    :: Pharma Z - Family drugstore ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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