Sometimes you might find yourself needing to repeat information in another location for convenience. Copying and Pasting from one location to the other. However, that is fraught with the danger of updating one area and not another. This is where linking data comes in.
For example, I have a list of expenses with a total at the end. Now repeat for each department. I want a summary of each department and the total expense in one location for ease of use.
Press the equals sign = where you want the result, proceed to now click on the sheet then the cell reference Press your operator such as Plus (+). Repeat the step for as many sheets as you like BUT when you finish no more (+). That is to say ensure you don’t have an extra (+) on your last cell reference and press enter to finish up.
Your result should look something like this:
In this example I have used the same cell reference this may not necessarily be the case for you. That is ok select which ever cell contains the result you are after.
With this technique you can make changes in cell A12 in Marketing and it will change in your summary page where you have the formula.
The process is the same if you were to select workbooks then sheets then cells.
The only danger is that people delete workbooks or move them to other locations, and this could break your link.
Making Changes To Linked Excel Workbooks
To make changes to a link you will need to go to the Data Tab and select Edit Links. From here you will be able to break links.
Be careful if you break a link there is no undo. Simply reinstate the link again. That means do the link steps again.
From this window you will see all the links that pertain to this Excel Workbook.