Calculations using two seperate spreadsheets

Sam - Sep 3, 2010 at 01:17 PM
 Sam - Sep 3, 2010 at 01:47 PM

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 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
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? ;)

You rock man! Thanks a ton!