Hi

This is me battling with trying to get a repeitive Hyperlink that takes me
to information that is 103 lines apart on another work sheet.

This Formula is in Row 5 of AI
=HYPERLINK("#'Road Cash Accounting'!,&ADDRES(5+103*(ROW()-409)))-27")

tHE CELL i AM INITIALLY TRY ING TO GET TO IS A111 ON Road Cash accounting.

What Am I doing Wrong
=HYPERLINK("#'Road Cash Accounting'!AI111" gets me there but I want it to
increase to A 214 WHEN
=HYPERLINK("#'Road Cash Accounting'!,&ADDRESS(5+103*(ROW()-409)))-27")
IS IN ROW 6 OF AI

hELP

sTEW