With the data on Sheet1, and the formulas elsewhere, try this:
=INDEX(Sheet1!$1:$1,ROWS(Sheet1!$1:1))*24
And copy down.
=INDEX(Sheet1!$A:$A,COLUMNS(Sheet1!$A:A))*24
And copy across.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Anne1320" wrote in
message ...
Thank you for the suggestions. Now the problem I've run into is that the
cells being referenced are on one worksheet and the target cells are on
another in the same workbook. ???
Can the solution to this be based upon either of the suggestions so
far, or do I need to look in another direction?
Thank you for your help.
--
Anne1320
------------------------------------------------------------------------
Anne1320's Profile:
http://www.excelforum.com/member.php...o&userid=35969
View this thread:
http://www.excelforum.com/showthread...hreadid=557570