after trying in vain to customize one of the many hyperlink formula examples available out here, I'm stumped. Most examples show linking between 2 sheets; I'm going for the 3D affect.
Example: Index of sheet names begin on Sheet1!A4. Sheet2!B2 needs a hyperlink referencing the destination sheet name in Sheet1!A4 to jump to the destination cell in Sheet3!A4, and so on.
surely this is doable? TIA
Example: Index of sheet names begin on Sheet1!A4. Sheet2!B2 needs a hyperlink referencing the destination sheet name in Sheet1!A4 to jump to the destination cell in Sheet3!A4, and so on.
surely this is doable? TIA