LinkBack URL
About LinkBacks
It would be a great help if you could provide me brief information to do it. Since i am not much familier with Pivot table and i have huge data.
The solution which you have proposed is working but data in sheet one is not changeable.
It would be a great help if you could provide me brief information to do it. Since i am not much familier with Pivot table and i have huge data.
The solution which you have proposed is working but data in sheet one is not changeable.
To recreate using the sample file do the following:
-> Delete existing sheet containing PT
-> Data
-> Pivot Table
-> Multiple Consoldiation Range
-> Next
-> I will create Page Fields
-> Next
-> Range (select all of your data - ie Sheet1!A1:E4 on example file)
-> Add
-> Finish
(the above instructions may vary slightly pending your XL version - this is not in your profile so can't be more exact)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks