exex-Large
New Member
- Joined
- Nov 8, 2005
- Messages
- 2
I have 4 workbooks named the following: -
Parts.xls
Model.xls
Warranty.xls
Report.xls
Is there a way to embed the first 3 workbooks into the Report.xls workbook? so that I have 1 workbook and so that I can run formulas on the Parts.xls, Models.xls and Warranty.xls.
If I can embedd the first three books into the Report.xls book, what would the formula statement look like, would it be similar to what I currently do:
(example) =IF('u:\excel\[Parts.xls]Service'!$A$2:$A$1000=B2,1,0)
Parts.xls
Model.xls
Warranty.xls
Report.xls
Is there a way to embed the first 3 workbooks into the Report.xls workbook? so that I have 1 workbook and so that I can run formulas on the Parts.xls, Models.xls and Warranty.xls.
If I can embedd the first three books into the Report.xls book, what would the formula statement look like, would it be similar to what I currently do:
(example) =IF('u:\excel\[Parts.xls]Service'!$A$2:$A$1000=B2,1,0)