Currently in the thinking stage right now but I am wondering if in excel VBA I have a report that comes in. This report then needs to be filtered by specific set of buildings. I just learned that you can add macros to the ribbon at the top of excel. INSTEAD of having a ton of buttons on the ribbon to select a specific set of buildings (buildings set A, Buildings Set B, Building Set C....Etc) is there a way that I could have it so I click a button to begin generating a report and it prompts the user to select a list of buildings.....
if that's confusing I guess an example would be the user clicks the button on the ribbon to run the report. A window pops prompting the user to select which set of buildings they would like to use (A, B, C, D....Etc) then the report runs and filters based off of the users prompted selection. If That makes sense??
I have a sheet that is a "library" of buildings if you will. This library contains multiple sheets each with different specific buildings on them. SO Ideally the user would be prompted to select the specific list they want to use before the actual macro runs. Because then each list is used to filter a master list down to those specific buildings.
if that's confusing I guess an example would be the user clicks the button on the ribbon to run the report. A window pops prompting the user to select which set of buildings they would like to use (A, B, C, D....Etc) then the report runs and filters based off of the users prompted selection. If That makes sense??
I have a sheet that is a "library" of buildings if you will. This library contains multiple sheets each with different specific buildings on them. SO Ideally the user would be prompted to select the specific list they want to use before the actual macro runs. Because then each list is used to filter a master list down to those specific buildings.
Last edited: