Hi!
I am having difficulties thinking through a solution to a problem I am having.
I have a pivot table with ID#'s grouped within Model Names at the left and then at the top I have Months (Jan - Dec) In the data I have the serial#s of the models counted.
E.g.
Jan Feb ...
ID1 - Model 1 1
ID1 - Model 2 2
ID1 TOTAL 1 2
...
See the attached file for the specifics
I have a display sheet with ID#'s in a drop down
I then have modeled names down the left and months across the top.
Not all IDs have the same models and not all months have models with counts either.
I'm trying to use the pivot table as the data source to populate the display sheet depending upon what ID# was selected from the drop down.
I was thinking of using getpivotdata, but I'm not too sure how to go about incorporating the ID#'s to drive the whole thing.
Any assistance would be greatly appreciated!
Bookmarks