Filter multiple tabs at the same time
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ZahinOsman
8 - Asteroid
‎11-19-2024
10:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Guys,
Was wondering if it was possible to filter multiple tabs at the same time? (Same schema/format)
Eg.
Example of the type of data found in these 3 tabs;
PaymentDate | FixingRate | FlowType | FlowSubType | Currency |
2024-11-13 | 1 | Payment | Exchange | USD |
2024-11-15 | 2 | Interest | Interest | USD |
2025-02-18 | 3 | Payment | Projected | USD |
2025-05-15 | 3 | Interest | Projected | USD |
2025-08-15 | 2 | Payment | Projected | USD |
What if i wanted to filter for only FlowType = Payment, but filter all 3 tabs at the same time? Is it possible? So far have not seen any solutions regarding this
Labels:
- Labels:
- Data Investigation
- Macros
2 REPLIES 2
flying008
15 - Aurora
‎11-19-2024
10:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @ZahinOsman
Maybe you can use batch macro or Dynamic input tool to input the data of 3 sheets at once, then filter by [FlowType].
nagakavyasri
12 - Quasar
‎11-21-2024
11:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
