Calculations using two seperate spreadsheets
Solved/Closed
Related:
- Calculations using two seperate spreadsheets
- Electrical calculations software - Download - Calculators
- How to use spreadsheets - Guide
- Compare excel spreadsheets - Guide
- How to create a calculator in excel using macros - Guide
- How to calculate vat using excel - Guide
2 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Sep 3, 2010 at 01:44 PM
Sep 3, 2010 at 01:44 PM
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? ;)
