ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking formulas from seperate workbook (https://www.excelbanter.com/excel-worksheet-functions/131685-linking-formulas-seperate-workbook.html)

Andy@cmk

Linking formulas from seperate workbook
 
I am using Microsoft Office Excel 2003. Im not sure whether this is possible
at all, but is there a way to make a formula where you extract data from
seperate workbooks? I know you can do this using seperate worksheets, but
unsure in regards to workbooks.

David Biddulph

Linking formulas from seperate workbook
 
Yes, but you can get into difficulties if the other workbooks aren't open
when you try to update values.
--
David Biddulph

"Andy@cmk" wrote in message
...
I am using Microsoft Office Excel 2003. Im not sure whether this is
possible
at all, but is there a way to make a formula where you extract data from
seperate workbooks? I know you can do this using seperate worksheets, but
unsure in regards to workbooks.





All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com