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) |