Hello, have a fun one here where I am trying to automate auto-populating multiple pivot tables. My challenge is, the way I set up the coding does not allow for multiple selections within a set criteria (such as "Level") so am looking to see if this could be coded better.
The attached is a much simplified version, but gives the general idea, where if I wanted to select all females at levels 2 and 3, the macro will not work because it reads the selection as "Multiple Items" versus using the two selected options. Any suggestions on how to best set up?
Thank you.
Sheryl
Bookmarks