merge data from two pivot tables?

U

ulfb

Pivot1 contains ALL clients. Pivot2 SOME clients. Datafields are different.
My idea is to use VBA to copy/paste both pivots to a new sheet, match client
rows in Pivot2 to Pivot1 to get one row per client. Finally delete column
with duplicate client id:s.

Is this a good approach or is there a better way?
If it is ok, how do I match rows to get one row per client? (excel 2003)

Grateful for any suggestions!
Ulf
 
D

David

Hi,

It is hard to tell what you want with out seeing what it is you have, but I
think you need to get back to the original data to start with. Get out of the
pivot table mode, back to the "data" and do your matches and eliminations to
start with.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL2002 - PivotTable 2 to Match Pivot Table 1 0
Merging from an Excel file with graphics 1
formula to get values from pivot table 1
Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables 3
Macro to add data once a Pivot Table has been refreshed 1
Create if partial match then copy and paste data from one cell to another 1
Find does not work in sheets with Pivot tables 0
Corrupt files due to pivot remnants after saving via VBA 0

Top