Importing Excel into new Excel file

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
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Create a dynamic master file 1
Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
Grouping Names in Mail Merge 0
Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top