Having a cell control an autofilter on another sheet

[philw12]

Hello:

I have a spreadsheet with a large data field that is sorted by autofilter. I want to have cells on another sheet that will control 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 (or select in a drop down box) and it to autofilter the above data for all entries with 2000 in the year column.

Thanks for the help!!!

Phil

[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.

[OLEG_V]

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.

Hi
Please be so kind and post the sample

Thank you

[teylyn]

Oleg, this thread is five years old. Nobody will return and post a sample file here.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.