Is there a way to link Auto Filter values to a Cell

G

Guest

Instead of going into each auto filter drop down box, I'd like to type a
value in a cell and have auto filter link to that cell so I can easily filter
along different criteria. Is this possible?

More specifically:

Column AM with about 3000 rows has % values 1-100%. I just want to return
bottom 10%. Currently I have to go into auto filter and the custom value to
less than .1. But going into the drop down box takes too long. Can I link
auto filter to a cell where I can just type in ".1" and have it filter the
entire column?

Is this a macro question? I hope not. Thanks...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto filter on columns 2
VBA: How can I use a string variable as autofilter criteria? 4
Filtering Using Values In A Specific Cell 3
auto filter / sumif 2
Auto Filter Comma Dilemiation 2
Auto Filter - It's broken! Help! (Office '03) 2
Auto Filter problems... 4
Cell protection & Auto Filter 1

Top