Is is possible to create formulas to calculate from one workbook t
another?
Yes. Simply reference the other workbook, sheet name and cel
reference in your formula as:
=IF('C:\Documents an
Settings\[Book1.xls]Sheet2'!$C24<>"",'C:\Documents an
Settings\[Book1.xls]Sheet2'!$C24,'C:\Documents an
Settings\[Book1.xls]Sheet10'!$L24)
note the syntax is: 'path\[workbook]SheetName!'CellReference
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
