| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summarize Data
What is the simplest method to total data from multiple excel files? The data
will have the same worksheet and cell reference in each file. I am trying to summarize data from over fifty excel files. I am trying to avoid opneing each file and pasting the cell reference from each file into my summary file. |
|
#2
|
|||
|
|||
|
Hi
Start here if you want a macro solution http://www.rondebruin.nl/copy3.htm More http://www.rondebruin.nl/summary2.htm http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruin http://www.rondebruin.nl "kgsggilbert" wrote in message ... What is the simplest method to total data from multiple excel files? The data will have the same worksheet and cell reference in each file. I am trying to summarize data from over fifty excel files. I am trying to avoid opneing each file and pasting the cell reference from each file into my summary file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| how to summarize and chart raw data | Charts and Charting in Excel | |||
| How to summarize data based on specific parameters | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
