Among the advantages offered Excel is to be able to link different spreadsheets. This makes the data that is in the sheets can be exposed in others.
In this way, you can count on much more detailed and separated by theme. For example, you can link a sell sheet with another that has all the accounting of your company.
It is not difficult to perform this task, you will have to be concentratedbecause any change you make in some you will make the result not be the correct one. Pay attention to the following paragraphs and you will become a professional.
What should we keep in mind before linking data between spreadsheets in Excel?
You can link spreadsheets both from the same document and of other. In this way you should consider that every time you make changes to any source template will cause changes to be generated in the cells of the sheets you have linked.
In case you have modified a sheet of another document and open the calculation template that has the destination cells, MS Excel will inform you that they occurred changes on the original sheet. Then, it will ask you if you want it to be set those variants.
Steps to link data between one spreadsheet and another in Excel
The steps to link data are as follows:
- Click on the cell to which you want to link the data.
- Then write the symbol “Same” (=).
- go to source cellswhich may be in a sheet of the same document or of another.
- You will see that the formula adopted the name of that sheet with an exclamation mark. For example, “=PAP!addition(“.
- then you can develop function as you need it most. That is, you will be able to incorporate functions such as SUM, SUMPRODUCTetc.
When you’re done, you will have to drag the destination cell so that the ones you select comply with the same conditions and so you can link them to the other sheets.
Facebook Comments
Disqus