Importing Excel into new Excel file

  • Thread starter Thread starter MaryfromHartford
  • Start date Start date
M

MaryfromHartford

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
 
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
 
Back
Top