Filter Sheet With text on cell

[adamsm]

Hi,

The code behind the attched workbook is designed to filter the sheet when the search text is written above the column headers.

The code works fine when the column starts from column A. But the code does not work fine when the column starts from column C.

How could the code be adjusted so that it would filter the sheet when the search text is written on row 9 above the column headers on any column from column C to column K.

Any help on this would be kindly appreciated.

[IBihy]

Hello Adam,
I don't quite catch on to the idea of typing search criteria above the heading row instead of using the drop-down for filtering, which works fine on both sheets. Nonetheless, I'm having a look.

Regards,
Isabella

[mancubus]

i think the origin of the worksheet_change event code is :
http://www.contextures.com/excelfiles.html#Filter

downloadable file may help
FilterClickColour_2007.zip (http://www.contextures.com/FilterClickColour_2007.zip)

[adamsm]

Thanks for the help & replies. I do really appreciate them.