Hi all,
I have successfully managed to automatically update my pivot table, so far so good.
However on a different sheet (call i XYZ) I have a summary of different groups for different months
Group Month 1 Month 2 Month 3 mONTH 4
A 1 2 3 4
B 5 6 7 8
C
D
I think you get the picture, anyways after each pivot table refresh I want the XYZ to also be updated by adding a new column for the existing groups and populating it with the values from the updated pivot table so that if in the refreshed pivot table i get a new column
Group Month 5
A 10
B 12
C 0
D 1
Then this new Month 5 would also get automatically updated in the XYZ sheet.
Hope above is clear otherwise let me know and I will specify more if possible.
Thank you in advance
Ryan
I have successfully managed to automatically update my pivot table, so far so good.
However on a different sheet (call i XYZ) I have a summary of different groups for different months
Group Month 1 Month 2 Month 3 mONTH 4
A 1 2 3 4
B 5 6 7 8
C
D
I think you get the picture, anyways after each pivot table refresh I want the XYZ to also be updated by adding a new column for the existing groups and populating it with the values from the updated pivot table so that if in the refreshed pivot table i get a new column
Group Month 5
A 10
B 12
C 0
D 1
Then this new Month 5 would also get automatically updated in the XYZ sheet.
Hope above is clear otherwise let me know and I will specify more if possible.
Thank you in advance
Ryan
Last edited: