Helping people with computers... one answer at a time.
You can easily link cells across workbooks in Excel. In fact, Excel itself will do most of the work for you.
How do you link cells in different Workbooks in Excel?
The Paste Link command is probably what you want.
Select the item you want to copy in one workbook and select Edit, Copy. Now in the other workbook, select the desired destination, and hit Edit, Paste Special, and press the Paste Link button.
If you take a look at the resulting formula it should include the filename, sheet name, and cell reference to original data.
Comments on this entry are closed.
If you have a question, start by using the search box up at the top of the page - there's a very good chance that your question has already been answered on Ask Leo!.
If you don't find your answer, head out to http://askleo.com/ask to ask your question.