Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ongoing hyperlink problem | Excel Discussion (Misc queries) | |||
Ongoing Average Calculation | Excel Discussion (Misc queries) | |||
how do i stop rows from being ongoing | Excel Discussion (Misc queries) | |||
I need a document to calculate an ongoing balance. | Excel Worksheet Functions | |||
Adding an ongoing value to an Average | Excel Worksheet Functions |