- Jan 7, 2019
- Office Version
Greetings, I completed a spreadsheet where I extrapolated from a database totals based on tons. These totals are on the same worksheet as the database. On that same database I have a drop down box where I can chose “Contingency”, “Humanitarian”, “Support”, and “All”. The drop down box begins at B2. The Totals from this database begins at K7. I am hoping I can identify totals based on the selection made within that drop down. I’m basically looking for a filter that will still keep my spreadsheet working properly. I’m trying to make it as easy as possible for the user to use a filtering process. I’m thinking a VBA with buttons labeled with the criteria. Thank you.