freefallin
New Member
- Joined
- Mar 21, 2011
- Messages
- 1
Hey guys,
I tried searching for this before posting, but came up a little short on this one. I have a database that has a column labeled "Category". This database is about 400 lines long and will continue to populate over time. What I would like to do, is create a macro button (or combo box) to allow a user to select only the categories they are interested in and then have that macro autofilter my main data sheet as well as my pivot tables based on it.
So far, I have created a drop down box (form control) that allows me to filter my pivot tables but only for one category at a time. I'd love to be able to have multiple categories if I can. I have not yet created a macro to filter my Main Data Sheet.
Any tips would be welcomed. I'm very new to macros and any coding so keeping it simple would be nice.
Thanks in advance!!!
John
I tried searching for this before posting, but came up a little short on this one. I have a database that has a column labeled "Category". This database is about 400 lines long and will continue to populate over time. What I would like to do, is create a macro button (or combo box) to allow a user to select only the categories they are interested in and then have that macro autofilter my main data sheet as well as my pivot tables based on it.
So far, I have created a drop down box (form control) that allows me to filter my pivot tables but only for one category at a time. I'd love to be able to have multiple categories if I can. I have not yet created a macro to filter my Main Data Sheet.
Any tips would be welcomed. I'm very new to macros and any coding so keeping it simple would be nice.
Thanks in advance!!!
John
