How to link excel files to compile data?

Excel spreadsheets are used to compile and calculate data. We can calculate large amounts by simply applying formulas in excel sheets.

Excel not only calculates values, but it can also be used to save and calculate data over many years in a single spreadsheet. See how can excel be used to compile your data over many years with some simple steps.

We have an excel sheet in which expense record is maintained on monthly basis. We have to compile record for the period of 2010-2020. You do not need to update both files each time. The only thing you have to do is to link files, by doing this, once you will update your monthly record, annual record file will automatically be updated. Let’s see how.

Step 01: Right-click on first cell in “total” column and Copy.

Step 02: Go to annual sheet, “Expenses Year 2010-2020”, and right-click on the first cell of “2010” column. Select “Paste special” and then click on “Paste link”.

Link entire column in the same way. If you make any change in monthly sheet, the change will automatically apply on annual sheet.  Two separate sheets can also be linked using the same formula.