I have this code that applies a filter across the whole workbook. Wanted to modify it only apply to certain worksheets within the workbook. I have a worksheet named "DEMAND" and "LOCATION", these are the worksheets I would want the filter to be applied to. Here is the code I have:
Dim xWs As Worksheet
On Error Resume Next
For Each xWs In Worksheets
xWs.Range("A1").AutoFilter 2, "=Jan"