"Avanced?" Filter

[comotoman]

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

 

[Juan Pablo González]

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

http://www.dicks-blog.com/archives/2004/11/22/advanced-filtering-in-vba/

 

[Debra Dalgleish]

You can use the Advanced Filter feature:

Add a heading to the list, unless cell A6 contains the heading
Add the same heading to cell D3
Select a cell in the list of numbers
Choose Data>Filter>Advanced Filter
For the List Range, use your range of numbers
For the Criteria Range, use D34
Click OK