| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Hyperlink
i have a problem which seems me very difficult to solve. i have not read about that on internet. infact i want to make hyperlink in such a way that when cell whick has link to other cell copied down the cell it linked to would also be changed as we observe in coping other functions & formulas. suppose i have hyperlink in cell "Sheet1!A5" linked to "Sheet2!B5", and in "Sheet1!A6" linked to "Sheet2!B25". i want that when cell "Sheet1!A6" copied down it should automatically create hyperlink with cell "Sheet2!B45". i want to have this without using VBA. please tell me if it could be done. waiting for a solution regards -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=524175 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Auto Hyperlink not workink | Excel Discussion (Misc queries) | |||
| Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| How do I disable the auto hyperlink feature in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
