Calculations using two seperate spreadsheets
Solved/Closed
Hello,
I am wanting to gather a number value already calculated in one excel spreadsheet and bring that number to another spreadsheet so I can use it in the second spreadsheet. I am an intermediate excel user, which is to say I am fairly decent at doing calculations, so be gentle and explain thoroughly please :)
I am wanting to gather a number value already calculated in one excel spreadsheet and bring that number to another spreadsheet so I can use it in the second spreadsheet. I am an intermediate excel user, which is to say I am fairly decent at doing calculations, so be gentle and explain thoroughly please :)
Related:
- Calculations using two seperate spreadsheets
- Spreadsheets formulas - Guide
- How to compare two excel spreadsheets - Guide
- Electrical calculations - Download - Calculators
- According to This Physicist's Calculations, We Are Indeed Living in a Computer Simulation - Home - Apps & Sites
- How to create a calculator in excel using macros - 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? ;)
