How to Connect Excel Spreadsheets

1. Open the two spreadsheets that you want linked (you should have two open windows).
2. Go to the worksheet you want to import data to and click on a cell that you want the imported data displayed.
3. Type an '=' sign into the formula window (the blank line at the bottom of the toolbar.
4. Navigate to the sheet you want to import the data from and click on the cell with the data. For example, click on cell A1.
5. Go back to the spreadsheet that you want the data imported to. Excel will paste the name of the worksheet and the cell reference into the formula line. Press 'Enter' and the imported total will show in the specified cell.