cell reference in a formula using 2 worksheets
=INDIRECT("'yearly data'!N5")
--
Regards,
Peo Sjoblom
"Oxpictas" wrote in message
...
Need help in getting formula in a seperate worksheet same workbook to stay
the same when I change the master work sheet.
Example
'yearly data'!N5 cell changes to 'yearly data'!N6 when I insert a line in
the master work sheet 'yearly data' I want the "'yearly data'!N5" to be
permanant no matter how many lines I insert into the "Yearly Data"
worksheet.
Please advise.
|