Does anyone know how to create one named reference across multiple
worksheets in the same workbook (BUT, not for the same cell reference
in each worksheet).
For example, the reference of TOTAL that could apply to cell A10 in
worksheet1, but A13 in worksheet2.
I know there is a way because I have inadvertantly done it for one
reference, I now need to replicate this and don't know how!

Please help


--
ajames
------------------------------------------------------------------------
ajames's Profile: http://www.excelforum.com/member.php...o&userid=31502
View this thread: http://www.excelforum.com/showthread...hreadid=526053