Using Filters

lhernandez

Active Member
Joined
May 22, 2006
Messages
282
I have a large database of approx. 6000 rows. When I use autoFilter and use a column to filter by is takes a very long time. Is there a reason for this?
I have other workbooks that that have 6000+ rows and this does not happen when I filter for those worksheets.
Is there any way I can make this go faster?
Thank you
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Why not use MS Query & input a parameter in a validation cell from your data..?
 

lhernandez

Active Member
Joined
May 22, 2006
Messages
282
I am unfamiliar with out to work with a Query.
I have a lot of people that use this database that are unfamiliar with Excel. It is just easy for them to filter on something they know copy the price and paste it from there.
Is a Query just as simple? and how does it work?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,735
Members
410,703
Latest member
yaronjoseph
Top