Consolidating data from many spreadsheets and comparing results over time
 

I have several spreadsheets that get disdributed to a large number of
end users (expense sheets and department budget spreadsheets). I need
a way, hopefully within excel, to consolidate some of the data from all
of the separate files into a consolidated view and compare the results
from period to period.

Does anyone know of an easy way to do this?

Thanks in advance,
Dave

Consolidating data from many spreadsheets and comparing results over time
 

Hi Dave

You can start here
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dave" wrote in message oups.com...
I have several spreadsheets that get disdributed to a large number of
end users (expense sheets and department budget spreadsheets). I need
a way, hopefully within excel, to consolidate some of the data from all
of the separate files into a consolidated view and compare the results
from period to period.

Does anyone know of an easy way to do this?

Thanks in advance,
Dave