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



"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