data consolidation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple sheets, each of which contains data used to calculate a single number for that sheet. So I end up with lots of sheets with their individual calculated numbers all in the same row and column. What I need to do is consolidate all of these numbers in a table on a new single sheet for further analysis (charting etc.). Is there a way to do that (other than to manually reference each cell)? If so, is there a way to have the final table automatically updated when new sheets are added?

Thanks!
Ryan
 
You can sum across sheets. If you put a "false" sheet in front of the "real" data sheets and sum through the false sheet, you can then add sheets behind the "false" sheet and summ accross the sheets will include new sheets added

----- Ryan wrote: ----

I have multiple sheets, each of which contains data used to calculate a single number for that sheet. So I end up with lots of sheets with their individual calculated numbers all in the same row and column. What I need to do is consolidate all of these numbers in a table on a new single sheet for further analysis (charting etc.). Is there a way to do that (other than to manually reference each cell)? If so, is there a way to have the final table automatically updated when new sheets are added

Thanks
Ryan
 
Back
Top