MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by Tanya on January 21, 2002 12:22 PM

In cell A2 of the BUDGET worksheet type
=BID!A5


Posted by George on January 21, 2002 1:20 PM

Thanks for your input Tanya. Actually there will be as many as 50 new sheets to link to. I'm trying to automate it so all I have to do is input the name of the new sheet in the BUDGET sheet. It needs a VBA solution