Hi Luke,
if my column which needs to be searched is not column A (it is Column AI) so what I have to amend in your code to get it work?
Thanks so much for your reply!
Don't need to amend the code, just change some things in the workbook. Unhide Sheet2, and change the value of cell A1 to be whatever header you want to do the filter on. The other part you may need to change is in the Formulas - Name Manager, make sure the definition of rngTable is the correct range of your table.