Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic creation of Hyperlinks
Hi there
Wondering if someone has a macro which scans through all cells in all worksheets and if it finds a cell which has the same value of one of the sheet names, it then converts that cell to a hyperlink to that sheet. For example, assume you have sheets names Sales, COS and GP and in the sheet Sales, cell A3 contains the text COS. It should then make this a hyperlink to the COS sheet. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress automatic formula creation? | Excel Worksheet Functions | |||
Automatic creation of worksheets | Excel Worksheet Functions | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Automatic Number Creation Problem? | Excel Worksheet Functions | |||
Automatic creation of an overview using several workbooks | Excel Programming |