How To Link Two Worksheets In Excel - Web go to data > consolidate. In the function box, select the function that you want excel to use to consolidate the data. Web a workbook link (previously called an external reference) is a way to combine data from other workbooks or other sheets in.
Web a workbook link (previously called an external reference) is a way to combine data from other workbooks or other sheets in. Web go to data > consolidate. In the function box, select the function that you want excel to use to consolidate the data.