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. |
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. |
All times are GMT +1. The time now is 06:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com