Hello.
I've got a cell that gives me the name of a worksheet that I need to use.
In that cell it can appear 6 different worksheets, and I want to the cell next to that create a hyperlink to the worksheet that is given in the first cell.
This is: cell A2: worksheet1
worksheet2
...
I need to, in cell A3, create a hyperlink that takes me to the worksheet that is presented on A2
(e.g A2: worksheet 2, A3 should contain a link to worksheet 2 and I would be able to open worksheet 2 with that hyperlink.
I already tried function hyperlink on Excel, but it doesn't seem to work. :/
I can't create a direct hyperlink because in cell A2, could appear worksheet 3 and if I go to cell A2 and I said that cell A2 corresponds to worksheet 3, even when appears worksheet 2, the hyperlink is to worksheet 3. :/
Please, can anyone help me?
Thanks
I've got a cell that gives me the name of a worksheet that I need to use.
In that cell it can appear 6 different worksheets, and I want to the cell next to that create a hyperlink to the worksheet that is given in the first cell.
This is: cell A2: worksheet1
worksheet2
...
I need to, in cell A3, create a hyperlink that takes me to the worksheet that is presented on A2
(e.g A2: worksheet 2, A3 should contain a link to worksheet 2 and I would be able to open worksheet 2 with that hyperlink.
I already tried function hyperlink on Excel, but it doesn't seem to work. :/
I can't create a direct hyperlink because in cell A2, could appear worksheet 3 and if I go to cell A2 and I said that cell A2 corresponds to worksheet 3, even when appears worksheet 2, the hyperlink is to worksheet 3. :/
Please, can anyone help me?
Thanks
