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
---
