Update Pivot table and create new columns

[Ryan1974]

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

 

[Ryan1974]

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 solved this myself