How to search and add an additional reference in a cell

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

Guest

To Julie, Frank or any other lords of excel.

I am trying to consolidate several spreadsheet into one
using the same template and format per sheet. Because of
the size I wish to add an additional spreadsheet for
which I will consolidate. Is it possible to ask excel to
look for specific cells and add other spreadsheet to the
total of each cells?

(i.e., =sheet1!a7+sheet2!a7+sheet3!a7, I would like excel
to add automaticaly sheet 4 and 5 whereever I am
consolidating those cells)

thanks

André
 
Anonymous wrote
...
I am trying to consolidate several spreadsheet into one using
the same template and format per sheet. Because of the size I
wish to add an additional spreadsheet for which I will
consolidate. Is it possible to ask excel to look for specific cells
and add other spreadsheet to the total of each cells?

(i.e., =sheet1!a7+sheet2!a7+sheet3!a7, I would like excel to
add automaticaly sheet 4 and 5 whereever I am consolidating
those cells)
Click to expand...
...

How would Excel know you were consolidating those cells?

A guess. If you create two blank worksheets named, e.g., alpha an
omega, then put all the worksheets you want to consolidate betwee
them, you could replace your formula above with

=SUM(alpha:omega!A7)

Then make sure you add worksheets between alpha and omega
 
Back
Top