This is my scenario.
- I have close to 20 worksheets in my Excel file. They have the different header columns.
- I need to filter on different columns , the criteria being different in all these sheets
- This filter needs to go in all the sheets.
Can anyone suggest a VB code for this? I am not very familiar with VBA looping and codes. Also unable to attach a excel file here
Appreciate any help on this.
- I have close to 20 worksheets in my Excel file. They have the different header columns.
- I need to filter on different columns , the criteria being different in all these sheets
- This filter needs to go in all the sheets.
Can anyone suggest a VB code for this? I am not very familiar with VBA looping and codes. Also unable to attach a excel file here
Appreciate any help on this.