Automated links between worksheets
Posted by George on January 21, 2002 12:03 PM
In a workbook with one sheet called BUDGET I would like to be able to create an automatic link to a new sheet that I have just created named BID. On the BUDGET sheet in cell A1 I input the name of the new sheet (BID) and in cell A2 of the BUDGET sheet it creates a link to cell A5 of the BID sheet.
Cell A2 of the BUDGET sheet will then equal what is in cell A5 of the BID sheet.