MrTwubbles
New Member
- Joined
- May 26, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
I am tracking data in 2 sheets with identical headers based on destinations. Sheet 1 is overall data, and sheet 2 is a subset of that. I use the data from both to select certain destinations. Once I select a destination to I don’t need, I use the drop down filter icon from the column header to filter it out. I am then having to duplicate this on the other sheet.
What I am trying to do is make it so that as I filter out a destination manually on one sheet, the other sheet will automatically apply the same filter.
Is there a way to do this?
What I am trying to do is make it so that as I filter out a destination manually on one sheet, the other sheet will automatically apply the same filter.
Is there a way to do this?