Hi,
I have been struggling with this problem for some hours now. I have a master sheet that contains a complete list of names; monthly totals and unique counts for each month. I would like to copy the pivot table values for each name to my master sheet. The only issue is that all the names may not be contain in pivot as the data varies on a monthly basis. I also run a code for unique count of name for each month that is also a field in the pivot (I have not included it in this example (if there are two or more entries for that name in the month, then it will count it once)).
Appreciate your help . . .
Bookmarks