Hi Folks
I've currently got a workbook with 5 spreadsheets. The first sheet
acts as a summary sheet and totals up the values in cell A1 in each of
the remaining four sheets. Here's my formula that sits on sheet 1:
=SUM('Sheet2'!A1+'Sheet3'!A1+'Sheet4'!A1+'Sheet5'! A1)
The thing is, I'm constantly adding new sheets to the workbook (e.g.
Sheet6, Sheet7, etc, etc) and, at the moment, I have to manually add
these to my formula on the summary sheet to get the correct totals
e.g.
=SUM('Sheet2'!A1+'Sheet3'!A1+'Sheet4'!A1+'Sheet5'! A1*+'Sheet6'!A1+'Sheet7'!A1*)
Is there anyway in Excel using either a built-in function or
VB that
could allow me to do something like this:
=SUM('*Any sheet other than this one*'!A1)
Any help much appreciated. Cheers!
--
Not2Bright
------------------------------------------------------------------------
Not2Bright's Profile:
http://www.excelforum.com/member.php...o&userid=15802
View this thread:
http://www.excelforum.com/showthread...hreadid=273042