i have a problem which seems me very difficult to solve. i have not read
about that on internet.
infact i want to make hyperlink in such a way that when cell whick has
link to other cell copied down the cell it linked to would also be
changed as we observe in coping other functions & formulas.
suppose i have hyperlink in cell "Sheet1!A5" linked to "Sheet2!B5", and
in "Sheet1!A6" linked to "Sheet2!B25". i want that when cell "Sheet1!A6"
copied down it should automatically create hyperlink with cell
"Sheet2!B45".
i want to have this without using VBA.
please tell me if it could be done.

waiting for a solution
regards


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=524175