PDA

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