jacksonworld
08-01-2005, 11:36 PM
Hi, I have a bit of a curly question.
I have cells in F2:F999 that contain worksheet names separated by commas.
eg. In Cell F3 (Note: There is a formula behind this), the display is as follows: Sheet2, Sheet4, Sheet6
These sheets already exist in my workbook.
My question is, how can I convert the text to worksheet hyperlinks?
That is, if I clicked on Sheet4 in Cell F3, I would be transferred to the actual worksheet Sheet4.
I hope someone can help.
Thanks
I have cells in F2:F999 that contain worksheet names separated by commas.
eg. In Cell F3 (Note: There is a formula behind this), the display is as follows: Sheet2, Sheet4, Sheet6
These sheets already exist in my workbook.
My question is, how can I convert the text to worksheet hyperlinks?
That is, if I clicked on Sheet4 in Cell F3, I would be transferred to the actual worksheet Sheet4.
I hope someone can help.
Thanks