Having a cell control an autofilter on another sheet

P

philw12

Hello:

I have a spreadsheet with a large data field that is sorted b
autofilter. I want to have cells on another sheet that will contro
the autofilter.

Here is my data source:

A B C
Year Name Time
2000 Ed 2
2001 Steve 4
2000 Mike 3

So, I want to be able on another sheet, enter "2000" in a cell (o
select in a drop down box) and it to autofilter the above data for al
entries with 2000 in the year column.

Thanks for the help!!!

Phi
 
E

Excel_Geek

You could write a simple macro.

Sub Filter_By_Year()

Selection.AutoFilter Field:=1, Criteria1:=Range("YEAR").Value

End Sub

Then name the cell you wish to use to control the filter "YEAR". You
can initiate the filter using a button or any other form, for that
matter.

Let me know if you'd like a sample spreadsheet.
 
Top