I have a workbook that has been split into numerous sheets according to specified column data via VBA
However I need the 1st row of each sheet to have the filter drop down options available. I could go through each sheet individually, highlight the top row and click filter, but as I have about 30 sheets each with numerous columns that's rather time consuming.
Can someone help me with the coding to do that please. I don't want to filter the data via vba, I just want each sheet to have the top row with the filter drop down buttons applied.