This is my scenario.
- I have close to 20 worksheets in my Excel file. They have the same header columns.
- I need to filter column C, the criteria being a text ("ABC")
- This filter needs to go in all the sheets.
Can anyone suggest a VB code for this? I am not familiar with VB and codes...