Calculations using two seperate spreadsheets Solved/Closed

Question

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 :)

Configuration: Windows XP / Internet Explorer 8.0

RayH · Answer

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

Sam · Answer

RayH,

You rock man!  Thanks a ton!

Calculations using two seperate spreadsheets

2 responses

Subscribe To Our Newsletter!