Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
Hi,
I need assistance on the workbook attached.
My question is how do I select any of the criteria and it will display at the Masterlist?
Any suggestions on excel? If not, a simple VBA?
Hope to hear from you soon.
Thanks.
Posted : 30/11/2019 4:41 am
Hi and welcome to our forum!
The solution here is to put your data in the correct Tabular format in a single table, not spread across multiple sheets. Then it's dead easy to use a PivotTable with Slicers to filter the data in your list. See file attached.
Mynda
Posted : 30/11/2019 6:16 am
