| 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 |
| 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 | |||
Threaded Mode
