1 of 1 people found this helpful
I'd like to use the official sample workbook "Superstore" as an example.
Main steps are,
1. Click the ▼ of the filter that you want to work on.
2. From the menu, select "Apply to Worksheets" -> Selected Worksheets...
(I suppose that your current setting is "Only This Worksheet".)
3. Select the worksheets that you want the filter to take effect on.
This is perfect, thank you!
Glad to hear that this worked for you!
Would you please take a moment to close this question by a simple click on the "Correct Answer" link in my previous reply?