MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Lookup on a sheet so that every time when file open it copes data from another file sheet

  Asked By: Matthew    Date: Aug 16    Category: MS Office    Views: 1072

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.



1 Answer Found

Answer #1    Answered By: Gilberto Thompson     Answered On: Aug 16

Open both files at once and create  your formulas using clicks into the data
in the second file.

Then, later, when you open  the first file, it should ask your permission to
update the values  from the other book.