Hi everyone,
I need some help filtering a table using VBA, please.
So I have my search criteria in cell A1 words like: "clean","materials" etc
In cell A2 I have a value that refers to my table header ex : A20, B20, C20 or D20
I want the code to look for the variable in cells A1 & A2 and filter the table based on them.
Any help is much appreciated.
Regards,
I need some help filtering a table using VBA, please.
So I have my search criteria in cell A1 words like: "clean","materials" etc
In cell A2 I have a value that refers to my table header ex : A20, B20, C20 or D20
I want the code to look for the variable in cells A1 & A2 and filter the table based on them.
Any help is much appreciated.
Regards,