Assuming IdNumber is the leftmost column of your source table, you could use
VLOOKUP

See Excel help and Debra's site for details.
http://www.contextures.com/xlFunctions02.html

"Mir Khan" wrote:

Hi Experts I need help...
I have 2 files
File 2 - destination table
There are few columns common in the 2 files...like IdNumber, Name, Manager,
Dept, etc.

My question is when IDNumber is entered in the destination file all other
common fields should get populate automatically?

Please help me this is very urgent...