ongoing question re hyperlink
Dear Pete
Thank You
STEW
"Pete_UK" wrote:
Try it this way:
=HYPERLINK("#'Road Cash Accounting'!A"&((ROW()-4)*103+8),"jump")
This gives the message "jump" in the cell, though you could miss this out if
you wish.
Hope this helps.
Pete
"stew" wrote in message
...
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
|