In this tutorial, we are going to look at how to link Excel workbooks. For example if you are tracking the same information from three shops – you will probably keep the information on each shop on a separate worksheet but then want to add up the information from the three worksheets together. These are also known as 3D formulas. In this tutorial I am going to show you how to create an excel link to worksheet.
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/linking_worksheets.m4v’]
Here is the file which you can download and practise on.