Neeraj Kumar
06-29-2010, 10:38 PM
Hi Dear,
In a workbook, In Sheet1 column is units, cust_id, cust_name, cust_city, cust_status. same column of sheet1 available in sheet2 also.
I want to create a pivot table with VBA from both worksheet data range (sheet1 data range and sheet2 data range).
When I Use XLCONSOLIDATION for Pivotcache then both worksheet consolidate and make a pivot table with Row,Column,Page........ fields, which i am not want.
I want to create a pivot from both worksheet datarange as all the column fields are used in pivot fields.
Any idea for create a pivot from merged datarange of both woksheets datarange. kindly make a VBA code for that and help me.
Thanks
Neeraj Kumar Singh
DS Group
:doh: :friends:
In a workbook, In Sheet1 column is units, cust_id, cust_name, cust_city, cust_status. same column of sheet1 available in sheet2 also.
I want to create a pivot table with VBA from both worksheet data range (sheet1 data range and sheet2 data range).
When I Use XLCONSOLIDATION for Pivotcache then both worksheet consolidate and make a pivot table with Row,Column,Page........ fields, which i am not want.
I want to create a pivot from both worksheet datarange as all the column fields are used in pivot fields.
Any idea for create a pivot from merged datarange of both woksheets datarange. kindly make a VBA code for that and help me.
Thanks
Neeraj Kumar Singh
DS Group
:doh: :friends: