ongoing question re hyperlink
 

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

ongoing question re hyperlink
 

I don't believe you can do it with formula alone as you cannot check the
state of the ongoing hyperlink via formula, you would probably need VBA
to accomplish this!


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24921

ongoing question re hyperlink
 

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

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

ongoing question re hyperlink
 

You're welcome, Stew - thanks for feeding back.

Pete

On Nov 4, 3:04*pm, stew wrote:
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- Hide quoted text -

- Show quoted text -