Project is shared, cannot use vba.
I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.
Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'
I've done something like this in the past, but cannot for the life of me remember how it was done. Sorry if this is a simple question.
Thanks for the help!
I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.
Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'
I've done something like this in the past, but cannot for the life of me remember how it was done. Sorry if this is a simple question.
Thanks for the help!