Dynamic links to another worksheet in same workbook?
Posted on 2013-05-24
I have a list of values in column A of Sheet1, as the user creates worksheets corresponding to values in Sheet1 I want to create hyperlinks on Sheet1 to the new worksheets.
Sheet1 Cell A2 contains a value "001", the user creates a worksheet call "Test-001", is it possible to create a dynamic hyperlink link to cell A1 in the new worksheet?
Dynamic so that the formula can be copied down for other cell vaqlues.