How to search and add an additional reference in a cell

To Julie, Frank or any other lords of excel.

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

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

thanks

Andr=E9

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)
...

How would Excel know you were consolidating those cells?

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

=SUM(alphamega!A7)

Then make sure you add worksheets between alpha and omega.


---
Message posted from http://www.ExcelForum.com/