John Smith
12/19/2006 2:02:00 AM
Use formula like this in file1
=[file2.xls]Sheet1!C4 (replace file2, sheet1, and C4 with
appropriate workbook name, sheet name, and cell.)
Anna wrote:
> Hi: Can any one please tell me how to i create a lookup in one sheet so
> that every time when file1 is open it goes into file2 and copy the
> values from the sheet of file2.
>
> Thanks.
>