Maybe you could use the indirect() function. You can then build an
address by combining data in different cells. ie
in column A, enter 1, 2, 3 etc down the column
in B1, enter "=7-7-"&A1&"!$O$45"
in C1 enter indirect (B1)
copy the whole lot down the columns and it should give you what you
want.
Matt
--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread:
http://www.excelforum.com/showthread...hreadid=561246