Fill cells automaticaly from other entry

From: wooptidooo (wooptidooo_at_discussions.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 09:59:08 -0800

I created a drop down list (data, validation) of employee names.
I would like the other cells to be filled out automaticaly for their adress,
city, phone
when I select one of the name from the list.