Apply filter from Sheet 1 to Sheets 2 and 3

NearImpossible

Registered User.
Local time
Today, 06:00
Joined
Jul 12, 2019
Messages
225
I have a workbook with multiple sheets and what I would like to do is be able to filter the data on Sheet 1, using the filter selections (Data > Filter), and then auto filter Sheets 2 and 3 to only show the selected filters from sheet 1.

Example:

I filter Column 1 on Sheet 1 and only select Fac 1 and Fac 2, when I click on either Sheets 2 or 3, i would like only Fac 1 and Fac 2 displayed on those sheets as well, etc. vs having to reapply the filter on each sheet.

In the end I will have 5 or 6 different Sheets with different information in Columns E-L, but Columns A-D will be the same on each Sheet

Is this possible?

please advise

thank you
 
Look at the Worksheet_Change event to apply the filter to the other sheets.
Use the Macro recorder to get the basics, and amend that code.
 

Users who are viewing this thread

Back
Top Bottom