If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel
how to reference first workbook from a second workbook in excel?
|
#2
|
|||
|
|||
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 --- |
Thread Tools | |
Display Modes | |
|
|