trying to develop a spreadsheet that has an embedded keyword filter at top of page...

[tonylombard]

so a user can easy get to records in the file without using the excel filter function....making it super easy for anyone to use.

can anyone help?


Tony

[tigeravatar]

Tony,

Welcome to the forum!

Attached is an example workbook based on the criteria you described.
In cell B1 is a drop-down list of the column headers so you can choose which column you're filtering by.
In cell B2 you can type in what you want to filter for.

Changing either of those cells will trigger the worksheet_change event:

Please Login or Register  to view this content.

Is something like that what you're looking for?

[tonylombard]

yeah thats even more than I need...only need the function on B2 to scan two columns and filter on the text inputed.

thanks so much...

Tony