Hi Kevin,
Your goal is to produce a string that looks like
sheet53!$C$2
and to place that formula adjusted to it's new location
as the argument of INDIRECT.
cell A61: 53
test G61: ="'sheet" & OFFSET(G61,0,1-COLUMN()) & "'!$C$2"
cell H61: =INDIRECT("'sheet" & OFFSET(H61,0,1-COLUMN()) & "'!$C$2" )
The G61 and H61 internal are the address of the cell itself
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"David McRitchie" wrote in message ...
Hi Kevin,
=ROW() will provide the cell's row number
=COLUMN() will provide the cell's column number
"KevinB" wrote ...
Cool, that worked! Thx!
Now, my next issue. The formula you provided;
=INDIRECT("Sheet"&$A$61&"!$C$2")