Question

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

Answer 1

Dear mate ...❤

ANSWER..

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 CopyRight-click a selected cell and then choose "Copy" from the context menu. Switch to the destination spreadsheet.

Select the Cell to Populate with DataSelect 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 SpreadsheetsRight-click the target cell.

Point to "Paste Special" and then press "N" to establish a link between the two spreadsheets.

Hoping that this answer is helpful...Mark as brainliest if you find soo..❤

Don't forget to follow...✌