| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using XP Operating System to Search for Numbers Values in Excel Files | Excel Discussion (Misc queries) | |||
| Saving files with a list of values | Excel Discussion (Misc queries) | |||
| Problem opening csv files with hexadecimal values | Excel Discussion (Misc queries) | |||
| How to save values only from linked Excel files? | Excel Discussion (Misc queries) | |||
| Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
Linear Mode
