Values from other Excel Files

S

Ski00000056

What would be the best way to get values from multiple excel files into a
separate file to do some SUM's?

Basically I have different Excel files, with multiple Worksheets in each,
that I need to get values from to do some summary formulas. Is it possible
to create formulas that look at other files or do I need to pull the data
from those files into the summary file and then do calculations?
 

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

Excel Unlink open excel files 2
Formula Calc Problem 7
Paste Values in linked Cells Only 4
Formula from other sheet(s) 1
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0
replace all formulas with values in multiple worksheets 5
Excel Excel macro to insert template sheet to all files in directory 0
Handling Large Files 3

Top