how to update data of excel file1 from excel file2?

Answer 1

http://support.microsoft.com/?kbid=211802
if you goto that an read about merge..
this should help explain, or at least give u a few pointers on where to start
hope this helps
Paultech
Remember to rate.

Answer 2

By creating a link between them
- go to file1 and copy the cell(s) you want
- go to file2 and select Edit > Paste Special > Paste Link
- and when the values in file1 is changed, you can see the changes in file2 after any edit happened.

Read my profile, I am the XLMan

Answer 3

simple just copy it and paste it in another file