Sarah52181
New Member
- Joined
- Mar 7, 2012
- Messages
- 19
Hello All,
I currently have a sheet that lists our sales by item by brand. There are 2 tables, one at the top that represents units and another below that to represent dollars.
I'd love to use a multiselect listbox to allow users to choose which brands they want displayed. (If the multiselect listbox won't work for me due to the nature of the output, I could use checkboxes but I don't feel they look as clean.)
My first thought is to write a macro that begins by hiding all data in both tables and then unhides selected rows if the proper brand appears anywhere in column B. I've also created named ranges for my "total" and "header" rows for both tables that I could unhide as a final step in the macro. This would allow me to almost treat the whole page as one data table rather than having to work on both tables separately (keeping up with ranges in the macros when we add new items, etc).
I've used both Form and ActiveX controls before but I can't seem to come up with anything that even gets me close to what I want to do here.
I considered writing a macro to auto filter the data, but I'm not sure how to make my macro reference the other selections so it doesn't just display the brand associated with that one selection. I also worry about keeping the range for the filter selection accurate as we add new items.
If someone could please point me in the right direction it would be much appreciated!
I currently have a sheet that lists our sales by item by brand. There are 2 tables, one at the top that represents units and another below that to represent dollars.
I'd love to use a multiselect listbox to allow users to choose which brands they want displayed. (If the multiselect listbox won't work for me due to the nature of the output, I could use checkboxes but I don't feel they look as clean.)
My first thought is to write a macro that begins by hiding all data in both tables and then unhides selected rows if the proper brand appears anywhere in column B. I've also created named ranges for my "total" and "header" rows for both tables that I could unhide as a final step in the macro. This would allow me to almost treat the whole page as one data table rather than having to work on both tables separately (keeping up with ranges in the macros when we add new items, etc).
I've used both Form and ActiveX controls before but I can't seem to come up with anything that even gets me close to what I want to do here.
I considered writing a macro to auto filter the data, but I'm not sure how to make my macro reference the other selections so it doesn't just display the brand associated with that one selection. I also worry about keeping the range for the filter selection accurate as we add new items.
If someone could please point me in the right direction it would be much appreciated!
