Can any one please tell me how to i create a lookup sheet. I mean every timewhen i open the excel file it automatically update the data into the sheet fromanother excel file.
If you put a formula into a sheet in a workbook linking to another workbook itwill 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 wantthe result to be. Press = and then click the cell in the other workbook youwant to obtain the data from. Then press enter.
Any reason why you've asked the same question on the same group, twice, butwith different subjects?