merge data from two pivot tables?
 

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

merge data from two pivot tables?
 

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

"ulfb" wrote:

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