Calculations using two seperate spreadsheets [Solved/Closed]

Report
-
 Sam -
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 :)

2 replies

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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? ;)
RayH,

You rock man! Thanks a ton!