You could do it either way:
=INDEX(Sheet1!$66:$66,ROWS(Sheet1!$1:224))*24
OR
=INDEX(Sheet1!$HP$66:$IV$66,ROWS($1:1))*24
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Anne1320" wrote in
message ...
this set of data is in Row 66, and I've got it referencing the correct
row on the correct sheet, but the data doesn't begin in Column A -
where do I put the reference to the beginning column (in this case
HP)?
Thanks again
--
Anne1320
------------------------------------------------------------------------
Anne1320's Profile:
http://www.excelforum.com/member.php...o&userid=35969
View this thread:
http://www.excelforum.com/showthread...hreadid=557570