If I could automate this task it would make my life easier, I am a VBA newbie
so this seems complicated to me. I am hoping some of the experts here might
be able to help. What I am looking at trying to accomplish is have some VBA
code that will allow a list of store numbers store be read and only select
those stores on the list in my pivot table rows. I have upwards of 250
stores that could potentially be analyzed by a monthly promotion. Where the
laborious work comes into play is one promo might include only 10 stores
(meaning I have 240 stores to uncheck) and another might have 175 that need
to be displayed. I will admit it does not take too long to manually go
through this list using the keyboard and checking/un-checking the stores, it
does leave room for error.
What I am envisioning is having code that would look at a range of cells in
a column and only display (check) the stores in that range. The list could
be copied onto the sheet where my table is located if this would make the
code easier. So I would copy the list of stores to my sheet, press a button,
and my pivot table would only show the stores in that range. Any help with
this would be greatly appreciated.
Thanks
|
Similar Threads
