asked on
VBA Code to create pivot in other excel file using other file's data
I have a file named A in which I have VBA coding to create pivot in file B using data or source data for pivot in file B itself. I am able to create pivot in same file but not in other bfile as said above. Please help
VBA
Last Comment
Sandesh S
ASKER
Hi Bill,
Apologies for delay and Thanks for your response.
Attached are the files wherein i have to create pivot in file OT. SPP is the file wherein i have the code and OT is the file wherein i have to create pivot using VBA coding. VBA code is working fine in file SPP if i try to create pivot in SPP file itself, but i want it to i.e coding in SPP to create pivot in file OT by using data in file OT itself, the same way as now it is doing in SPP.
Thank you in advance.
SPP.xlsm
OT.xlsx
Apologies for delay and Thanks for your response.
Attached are the files wherein i have to create pivot in file OT. SPP is the file wherein i have the code and OT is the file wherein i have to create pivot using VBA coding. VBA code is working fine in file SPP if i try to create pivot in SPP file itself, but i want it to i.e coding in SPP to create pivot in file OT by using data in file OT itself, the same way as now it is doing in SPP.
Thank you in advance.
SPP.xlsm
OT.xlsx
Which procedure, in which module, are you using?
»bp
»bp
ASKER
Hi Bill,
I am using Sub createPivotTableExistingSh
Thanks & Regards,
Sandesh
I am using Sub createPivotTableExistingSh
Thanks & Regards,
Sandesh
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Bill,
It is working perfectly fine.
I am thankful to you that you helped me at the right time. I really appreciate for all you have done to help me. I just want to say fabulous for your effort. I think you don't mind if come up with any other challenging situations like this.
Thanks again...!
Sandesh
It is working perfectly fine.
I am thankful to you that you helped me at the right time. I really appreciate for all you have done to help me. I just want to say fabulous for your effort. I think you don't mind if come up with any other challenging situations like this.
Thanks again...!
Sandesh
Welcome, always glad to help.
»bp
»bp
ASKER
I would like to thank Bill Prew for helping to fix this. Keep up the spirit. Thanks, Sandesh
»bp