Calculations using two seperate spreadsheets
Solved/Closed
Related:
- Calculations using two seperate spreadsheets
- Spreadsheet calculations - Guide
- Google spreadsheets download - Download - Spreadsheets
- How to match two spreadsheets in excel - Guide
- Refresh calculations in excel - Guide
- Electrical Calculations - Download - Calculators
2 responses
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
3 Sep 2010 à 13:44
3 Sep 2010 à 13:44
in the second spreadsheet and in the cell that you want to see the value from the first spreadsheet put:
='C:\Documents\[first spreadsheet.xls]Sheet1'!A1
This will pick up the value from cell A1 in the first speadsheet and put it in the second spreadsheet in the cell you chose.
Gentle enough? ;)
='C:\Documents\[first spreadsheet.xls]Sheet1'!A1
This will pick up the value from cell A1 in the first speadsheet and put it in the second spreadsheet in the cell you chose.
Gentle enough? ;)
