Question

How do you link two or more sheets in a workbook?​

Answer 1

Answer:

Open Both Workbooks

Open both workbooks, if applicable.

Select the Source Spreadsheet

Select the source spreadsheet. Highlight each cell you want the destination spreadsheet to link to. Hold "Ctrl" while clicking to select multiple cells.

Choose Cells and Copy

Right-click a selected cell and then choose "Copy" from the context menu. Switch to the destination spreadsheet.

Select the Cell to Populate with Data

Select the cell where the source data should be populated. If transferring data from multiple cells to a group of cells, choose the upper left-most cell in the group.

Establish a Link Between the Two Spreadsheets

Right-click the target cell. Point to "Paste Special" and then press "N" to establish a link between the two spreadsheets.

Explanation:

You can also create links in Excel from the destination spreadsheet. Select the destination cell and then press "=". Go to the source spreadsheet, select the cell to link the destination cell to, and then press "Enter."