View Full Version : Create Pivot table from multiple worksheet
Neeraj Kumar
06-27-2010, 11:37 PM
Hi Dear,
This is Neeraj Kumar Singh, Kindly help me in VBA!
I have two worksheet named sheet2 and sheet3
Both Worksheet have data with same column. I want to create a pivot table in sheet1 from both worksheet (sheet2 and sheet3) source data range.
How do create this pivot table by VBA?
Bob Phillips
06-28-2010, 12:31 AM
Do it in Excel with the macro recorder on this will generate your code.
Neeraj Kumar
06-28-2010, 04:00 AM
Do it in Excel with the macro recorder on this will generate your code.
Thanks for your quick responce,
but what this code. i am not doing the datasource for the XLconsolidation
and i couldn't consolidate the both sheetdata Range for pivotcache.
How do the consolidate that?
Bob Phillips
06-28-2010, 04:14 AM
I don't understand what you are saying.
Did you understand what I suggested and did you try it?
Neeraj Kumar
06-28-2010, 04:51 AM
I don't understand what you are saying.
Did you understand what I suggested and did you try it?
Kindly send me you own email-ID.
that I will sent You with attached file and detail and support me.
Thanks
Neeraj Kumar
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.