B
BabyMc
Hi
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
sheet.
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
"Sheet4".
In another sheet I would have
A
1 Sheet1
2 Sheet2
3 Sheet3
4 Sheet4
then in cells B1 to B4 have a formula that jumps to the sheet named in A1 to
A4.
Thanks
PS - I'm not very good with macros so I was hoping for a formula.
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
sheet.
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
"Sheet4".
In another sheet I would have
A
1 Sheet1
2 Sheet2
3 Sheet3
4 Sheet4
then in cells B1 to B4 have a formula that jumps to the sheet named in A1 to
A4.
Thanks
PS - I'm not very good with macros so I was hoping for a formula.