Excel
 

Is is possible to create formulas to calculate from one workbook to another?

Excel
 

Is is possible to create formulas to calculate from one workbook to
another?

Yes. Simply reference the other workbook, sheet name and cell
reference in your formula as:

=IF('C:\Documents and
Settings\[Book1.xls]Sheet2'!$C24<"",'C:\Documents and
Settings\[Book1.xls]Sheet2'!$C24,'C:\Documents and
Settings\[Book1.xls]Sheet10'!$L24)

note the syntax is: 'path\[workbook]SheetName!'CellReference

good luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=483493