Advanced filter macro

[stinkywack]

I have a spreadsheet with over 20,000 rows of information. Since autofilter only supports up to 1,000 unique criteria, I need to make a macro to filter the list based on an input cell. For example, the data is in range A1:M20974, and there is a list of stock symbols in Column A. I need to set up a macro to filter out a particular stock when it is typed into a separate cell. Ideally, the user could go to sheet2 and there will be a cell where they can type the symbol, and all the rows that had the symbol from Sheet1 is displayed just below it. If I have to create a button assigned to the macro, I can do that. I am just having trouble with the macro.

Note: I am by far not an expert, but the people I am putting this together for have very little excel knowledge.

Thanks.

[Kieran]

Thsi is quick example of a VBA solution.

Hope it helps you.