Excel 2010 - transferring data

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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,108,626
Messages
5,523,978
Members
409,549
Latest member
agus setiawan

This Week's Hot Topics

Top