CRUTHERFORD
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 107
Hi,
I just wanted to get some ideas on how I could extract pivot table data from one excel document to another in order to populate certain cells?
Eg.
In Excel1.doc, I have a pivot table with different columns giving different values such as: Revenue, Commission etc. I want to take this data and populate certain cells within my Excel2.doc - any thoughts on how I can do this easily rather than copying and pasting each individual cell?
Cheers
I just wanted to get some ideas on how I could extract pivot table data from one excel document to another in order to populate certain cells?
Eg.
In Excel1.doc, I have a pivot table with different columns giving different values such as: Revenue, Commission etc. I want to take this data and populate certain cells within my Excel2.doc - any thoughts on how I can do this easily rather than copying and pasting each individual cell?
Cheers