Hi All,
I am a beginner in Excel that is why I’m humbly asking for your help regarding below concern. I’m really hoping that you can assist me for it will really help me a lot in my job. Your assistance will be greatly appreciated. Thanks a lot in advance!
Is it possible to have a macro that will create a pivot table to an existing sheet?
I have two sheets named “Pending Asia” and “Pending Asia Pivot”. What I wish to happen is to create a pivot table using ‘Pending Asia’!B:P as reference of the table then insert the table to an existing sheet named “Pending Asia Pivot”, please put the table in column A8 of sheet “Pending Asia Pivot”. Add to report the field “Number of Days Pending” (This is column B in Pending Asia!) in Row Labels, Field name “Status Changed to” (Column M in Pending Asia!) in Column Labels and fieldname “Activity ID/Team Track” (Column F in Pending Asia!) to Values area.
Again, I am pleading for your help about this.
Thanks a lot and more power!
Regards,
papajups
I am a beginner in Excel that is why I’m humbly asking for your help regarding below concern. I’m really hoping that you can assist me for it will really help me a lot in my job. Your assistance will be greatly appreciated. Thanks a lot in advance!
Is it possible to have a macro that will create a pivot table to an existing sheet?
I have two sheets named “Pending Asia” and “Pending Asia Pivot”. What I wish to happen is to create a pivot table using ‘Pending Asia’!B:P as reference of the table then insert the table to an existing sheet named “Pending Asia Pivot”, please put the table in column A8 of sheet “Pending Asia Pivot”. Add to report the field “Number of Days Pending” (This is column B in Pending Asia!) in Row Labels, Field name “Status Changed to” (Column M in Pending Asia!) in Column Labels and fieldname “Activity ID/Team Track” (Column F in Pending Asia!) to Values area.
Again, I am pleading for your help about this.
Thanks a lot and more power!
Regards,
papajups