| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge data from two separate tables | Excel Worksheet Functions | |||
| Merge data from two separate tables | Excel Discussion (Misc queries) | |||
| Any way to programmatically make pivot tables behave more like data tables? | Excel Programming | |||
| Merge & Match 2 Excel Data Tables | Excel Programming | |||
| Merge Pivot Tables | Excel Discussion (Misc queries) | |||
![ulfb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
