were going to show you how to link information between Excel 2016 files.
- join us on Facebook
The easiest way to do that is to select what we want to copy over, click Citrl+C and then paste it where we want it to be.
If we click on the Ctrl button icon appeared right here, we will find an option called Paste Link. Then, if we change the original file somehow, we will see that all the data will automatically update
Rachel: Lets say I have Sales Projections and Actual Sales for Multiple Stores on Multiple Pages and I link them all on one page for totals, now I want to find the percentage difference between the Sales Projections and Actual Sales from these linked totals, how do I? Date: 2023-07-08