Importing Excel into new Excel file
 

Hello all,
I want to pull cells from 10 Excel files on pc into one new file. Can I do
this with a simple cell reference to the path and filename where the data is
coming from? Thanks!
Mary

Importing Excel into new Excel file
 

Hi,
yes you can for example in the cell you want the consolidation

='[your file name.xlsm]sheet1'!$G$11+'[your 2nd file name .xlsx]sheet1'!$T$5

to make it easier enter = in you cell and with all the other sheets open
start going to that sheets and clicking in the cell you want to pull the
information from



"MaryfromHartford" wrote:

Hello all,
I want to pull cells from 10 Excel files on pc into one new file. Can I do
this with a simple cell reference to the path and filename where the data is
coming from? Thanks!
Mary