Consolidating data from 40 worksheets

  • Thread starter Thread starter rheller
  • Start date Start date
R

rheller

I have a bunch of worksheet templates (about 40) sent out for people t
fill out. I am looking to consolidate the data in one master exce
worksheet. What is the best way to accomplish this? I have trie
linking sheets, but within the master sheet worksheet, I am usin
=SUM() and the formula just gets too long. Any suggestions would b
greatly appreciated. Thank you
 
I decided to use the DATA->CONSOLIDATE on the menu. This seems to wor
fine as I am able to add from 26 worksheets into a single cell. Thanks
 
Thank you for your help. Is there a way to consolidate the data so tha
it shows a name (perhaps off a left menu) that will show me quickl
which data it is sourcing the information from when the consolidatio
is expanded by clicking on that arrow?



Is it possible to copy a consolidation function I used by going t
DATA->CONSOLIDATE to other cells? You would figure that when I copy th
cell in the master sheet to the cell just to the right of it, that i
would duplicate the process, but it doesn't seem to
 
Back
Top