Microsoft Office 2016: The Complete Guide (2015)

HOW TO CREATE AN EXTERNAL REFERENCE LINK TO WORKSHEET DATA ON THE WEB

An external reference or link that is located on your internet can be transferred from one workbook to another once it is not saved as an HTML file.

Bring up the workbook that you will use and then choose the cell or series of cells that should be copied.

Go to the Home tab, and select the Clipboard group, and then choose the option Copy.

Next, go to the workbook that the information should be inserted into and then select the cell where the information will be displayed.

Go to the Home tab, and select the Clipboard group, and then choose the option Paste Special.

Then select the option Paste Link.