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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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?
 

Forum statistics

Threads
1,141,924
Messages
5,709,369
Members
421,632
Latest member
BrennieB

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top