Can any one please tell me how to i create a lookup in one sheet so thatevery time when file1 is open it goes into file2 and copy the values from thesheet of file2.
Open both files at once and create your formulas using clicks into the datain the second file.Then, later, when you open the first file, it should ask your permission toupdate the values from the other book.