Values from other Excel Files
 

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?

Values from other Excel Files
 

Please disregard this thead. Thanks!

"Ski00000056" wrote:

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?