Hi all,
Does anybody know how to solve this reference problem in Excel?
I have multiple sheets. The first sheet is a summary of all other sheets.
The Sum-sheet has two columns with the following cell contents:
Sheet # Value
---------------------
2 ='2'!$C$4 value from sheet 2 of cell C4
3 ='3'!$C$4 value from sheet 3 of cell C4
4 ='4'!$C$4 value from sheet 4 of cell C4
etc.
Is there any way of using the sheet value (column 1) in the second column's
formula?
Something like this: =SHEET($A$1)!$C$4 where $A$1 is the first column.
Thanks for any help.
John.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
