|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 30th, 2002, 05:51 PM
|
#1 |
|
Board Regular
Join Date: Apr 2002
Posts: 139
|
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?
|
|
|
|
Apr 30th, 2002, 06:09 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Christchurch New Zealand
Posts: 1,030
|
not that i know of with autofilter have you got a lot of formulas?
|
|
|
|
|
Apr 30th, 2002, 06:14 PM
|
#3 |
|
Board Regular
Join Date: Apr 2002
Posts: 139
|
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
|
|
|
|
|
May 1st, 2002, 01:17 PM
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
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 :: |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
