Forum Discussion
Dynamic Filter Multiple Columns
If you organize the data structure as per what is suggested by Detlef_Lewin, it would be easy for you to generate reports using the Pivot Table and filter it as per your requirement.
Another way is, you can use Power Query to filter the data in the existing format and get the filtered table back on to the sheet.
In the attached, change the color criteria in cell E2 and the table on the right would be updated automatically. This functionality utilizes Change Event code which is placed on Sheet1 Module and it is there in order to avoid manually refreshing the table returned by the Power Query. So once you change the criteria in E2, this code is executed automatically and refresh the Query to return the updated table on the sheet.
See if this is something you can work with.
If you organize the data structure as per what is suggested by Detlef_Lewin, it would be easy for you to generate reports using the Pivot Table and filter it as per your requirement.
Another way is, you can use Power Query to filter the data in the existing format and get the filtered table back on to the sheet.
In the attached, change the color criteria in cell E2 and the table on the right would be updated automatically. This functionality utilizes Change Event code which is placed on Sheet1 Module and it is there in order to avoid manually refreshing the table returned by the Power Query. So once you change the criteria in E2, this code is executed automatically and refresh the Query to return the updated table on the sheet.
See if this is something you can work with.
Very helpful, exactly what I had in mind.
Glad you found it helpful.
