How to link between two workbooks (files) in Excel

Often we need to summarise information from one (or many) Excel files into another.  Doing this is very easy; to begin, you will need both of your files open; the file that you want to retrieve the information from, and the file you want the information to go to.  If you open each workbook side by side on your screen it makes this process the easier.  Select the data on the sheet you want to copy from, copy it, then in your destination workbook select where you want your linked data to go, right-click with your mouse and select the "Paste Link" icon: You will notice if you select a cell in your destination workbook that it now contains a formula that refers to a corresponding cell in your source data workbook.  Here you can see that cell F2 is referring to Workbook 1.xlsm, Sheet1, cell F2: If you make any changes to your source data workbook, they will be automatically changed...
Read More