You can do it using VBA. Here's an example:

http://www.dicks-blog.com/archives/2...tering-in-vba/

--
Regards,

Juan Pablo González
Excel MVP

"comotoman" wrote
in message ...

Is there a macro or a way to base auto filter on a cell number.

a6:a100 is the filter area. (numbers 1-12)
d4 could be a number from 1-12

i would like a6:a100 to filter by the d4 entry.

Thanks.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile:
http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473002