Consolidating data from many spreadsheets and comparing results over time

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Consolidation function 2
Selecting data from multiple worksheets 5
Formula to consolidate 130 sheets into a summary sheet 6
Incrementing rows and columns 1
Finally, a SIMPLE solution for Excel file Consolidation 4
Consolidating Data to one worksheet 4
Consolidate many WBs into one ... 2
Data Consolidation 1

Back
Top