I have two sheets in a workbook. I am using the following VBA code to filter the data:
Sub apply_autofilter_across_worksheets() 'Updateby Extendoffice 20160623 Dim xWs As Worksheet On Error Resume Next For Each xWs In Worksheets xWs.Range("A4").AutoFilter 1, "=001" Next End Sub
Now I want to use the value in cell F1 in place of 001. How do I modify the code?