Filtering & clearing combo control boxes with vba

[5150]

All,

I need your help to modify the VBA code that is currently assigned to all (3) Filters (Combo Box Form Controls) in the DB Tab. Specifically, I need each filter in the DB tab to filter and maintain each filter level. Then, when I select “All” on each filter, it should clear each filter level in the DATA tab, just as if you were filtering directly in the DATA tabs. Currently, the VBA code filters only one at time and does not hold multiple filters simultaneously.

All I’m trying to do is filter from the DB tab instead of the DATA tab to create a cleaner Dashboard rather than having all the DATA and calculations on the same tab.

I’m almost there I just need these final component to accomplish my objective.

I appreciate your help so much guys!

[AlphaFrog]

Assign this one macro to each of the three drop down form controls.

Please Login or Register  to view this content.