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.
Here is the file which you can download and practise on.