Autofilter Column of Data Based on Cell Input

[juliettelam]

Hi,
I have a table of data which I would like to filter based on a manual cell input instead of the autofilter option.

The table has tickers in column B and has information from column B to U. I would like to filter the data based on a manual ticker that I enter.

Does anyone know how to do this / if it is possible? THank you!

[HaHoBe]

Hi, juliettelam,

with the way you want the AutoFilter to work I would suggest to use the Advanced Filter on a sheet with both Criteria and Destination Range while the Data Range is on a different range.

You could use the Worksheet_Change-event to deliver the new value to the AutoFilter but you should make clear where you want the ticker entered and where the data starts.

Ciao,
Holger

[juliettelam]

Hello

Thank you for your response, I am very new to excel could you elaborate on each way? I'm not sure how to do either.

[HaHoBe]

Hi, juliettelam,

what about answering my questions before I try to write books for a solution that may not fit?

Ciao,
Holger

[juliettelam]

Hi Holger

The worksheet change event seems to exactly fit what I am looking for. Thanks for your help!

[HaHoBe]

Hi, juliettelam,

have a look at the workbook attached. Range to enter the criteria is C3 (Data/Validation), all the code is behind Tabelle1:

Please Login or Register  to view this content.

Ciao,
Holger

[juliettelam]

that works perfectly!!!!!!!!!!!!!!!!!!!! thank you SO much