MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Lookup Sheet

  Asked By: Alfonsa    Date: Jan 31    Category: MS Office    Views: 1583

Can any one please tell me how to i create a lookup sheet. I mean every time
when i open the excel file it automatically update the data into the sheet from
another excel file.



2 Answers Found

Answer #1    Answered By: Abbas Hashmi     Answered On: Jan 31

If you put a formula into a sheet  in a workbook linking to another workbook it
will ask you if you want to update  the links every time you open  it.

To create  this formula have both sheets open. Click the cell where you want
the result to be. Press = and then click the cell in the other workbook you
want to obtain the data  from. Then press enter.

Answer #2    Answered By: Jana Franklin     Answered On: Jan 31

Any reason why you've asked the same question on the same group, twice, but
with different subjects?

Didn't find what you were looking for? Find more on Lookup Sheet Or get search suggestion and latest updates.