-
VBA Code for pivot table from multiple worksheet
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules