Excel
how to reference first workbook from a second workbook in excel?
|
Excel
" wrote:
how to reference first workbook from a second workbook in excel? Let's say you have both Book1.xls and Book2.xls open at the same time In Book2.xls, in any sheet, you could link it by placing in any startcell, say in B2: =IF([Book1.xls]Sheet1!A1="","",[Book1.xls]Sheet1!A1) Then just copy B2 across/fill down to cover the desired linked source range in Book1.xls' Sheet1 Note that the relatively simple-looking link formula above will auto-adjust to include the drive/directory/path once you close Book1.xls, which can (and usually does) appear hideously long & frightening. Hence its always much easier to frame the links up with both source and destination books simultaneously open. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
All times are GMT +1. The time now is 01:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com