Hi ,
i need to create a pivot table with the use of two data sheets, is thr any way to achieve this other than by using multiple consolidate range ?/
thanks in advance
rj
Hi ,
i need to create a pivot table with the use of two data sheets, is thr any way to achieve this other than by using multiple consolidate range ?/
thanks in advance
rj
Don't think so.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
If the sheets are in an external file and identical in terms of columns etc you could use an external data pivot and conduct a SQL Union of both sheets (into one source).
Example (PT source) SQL:
Please Login or Register to view this content.
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)
Bookmarks