1. Open both workbooks.
  2. Select the source cells.
  3. Right-click and choose Copy.
  4. Using the Window menu, switch to the destination workbook.
  5. Select the first destination cell.
  6. Right-click and choose Paste Special.
  7. Choose Paste Link.