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.
i m using Excel 2003 & XP on different systems.

waiting for a solution
regards