To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Excel has its own functions for simple layout, but if you are writing a report or similar and want to use data from large Excel tables, it’s easy to link the two Office programs.

How to Link 2 Excel Spreadsheets. You can establish links across multiple spreadsheets and workbooks in Microsoft Excel to streamline data management.

An curved arrow pointing right. You can create reports in Word and PowerPoint that are linked to tables and charts in Excel. Produced by Sara Silverstein Follow BI Video: On Facebook More from ...