Update Pivot table and create new columns

Ryan1974

New Member
Joined
Sep 12, 2012
Messages
10
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
 
Last edited:

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Ryan1974

New Member
Joined
Sep 12, 2012
Messages
10
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,909
Messages
5,525,581
Members
409,651
Latest member
Quasar Hunter

This Week's Hot Topics

Top