Linking info into Excel worksheet from an Excel Template
Posted on 2012-03-14
I have a template that someone will be entering data into and saving/renaming it to a workbook. Then a different person will open up another workbook that I want to link some of the cells from the first workbook to the new workbook. Since employee 1 will rename the workbook, how do I easily update the link in workbook? The first template will be used over and over and saved a new name each time. What I don't get is how to update the new workbook link each time. The cells will remain the same however. This needs to be relatively simple since the user(s) are not computer savvy. The first employee will notify the second employee the name of the new workbook name. What would be great is if there was a way for the second employee to type the name of the first workbook in a cell and voila...the links would update.