Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will take a look at accessing data from another workbook. We will show you how updating one cell on a different sheet on a workbook can update a link cell on a different worksheet on the same workbook. We will demonstrate drag-drop links, pasting links, as well as editing links.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Welcome back to our course on Excel 2016 Advanced.
So far with virtually everything we’ve covered on the course we’ve been looking at self-contained workbooks, workbooks that have all of their own data within them. And even when we needed data from outside we imported it into the workbook that we were using. But there are occasions when you want to have access to data from outside but on an ongoing basis.

So rather than import the data into a workbook we want to be able to link to it from one or more workbooks. And in some of those instances we may even be depending on what is in effect a real time update from outside.

Now I’m going to cover three different scenarios here. In this section I’m going to look at accessing data from another workbook, then we’re going to look at accessing data from an Access database and then in the third of these sections we’re going to look at accessing data from the web. Now as I said, in all three of these cases we’re going to be looking at situations where the data is held outside of one of our workbooks and in effect we’re not importing it.

We’re leaving it outside but setting up a mechanism whereby our workbook can get that data and potentially be updated in real time with that data from that outside source.
Now in the first example that I’m going to use I’ve got some sales data from two South American divisions of a company. One division based in Bogota and one based in Lima, Peru. And for each of them I have their sales figures for 2015.

Now Bogota sales are on one sheet, Lima sales are on another sheet. And what I’m going to do is put together a summary sheet. And the summary sheet will combine the two sets of figures. At the moment all of this data is within a single workbook and we’re going to separate this into different workbooks a little bit later in this section. So first of all let me put in the framework for this summary sheet.

Okay my framework is in place. What I’m now going to do is to copy the figures from the Bogota sheet and the Lima sheet. So for the Bogota sheet I’m going to select the cells, copy them to clipboard, back to the summary sheet, they’re pasted into place. And then I’m going to the Lima sales, copy those, back to the summary.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.