Auto populating fields

I have a form that asks for Name, Job Title, Employee ID number, etc. I can
create a drop down list using Validate no problem. However, I want to be able
to automatically populate the fields when a person's name is selected.

For example, if I select Billy from the Name drop down list, the Job Title,
ID Number, etc. gets automatically filled.

Mark, use a look up table, have a look here for details

http://www.contextures.com/xlFunctions02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mark" <[email protected]> wrote in message
news:[email protected]...
>I have a form that asks for Name, Job Title, Employee ID number, etc. I can
> create a drop down list using Validate no problem. However, I want to be
> able
> to automatically populate the fields when a person's name is selected.
>
> For example, if I select Billy from the Name drop down list, the Job
> Title,
> ID Number, etc. gets automatically filled.
>
>

Thanks Paul. It works! Great stuff!

Mark

"Paul B" wrote:

> Mark, use a look up table, have a look here for details
>
> http://www.contextures.com/xlFunctions02.html
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Mark" <[email protected]> wrote in message
> news:[email protected]...
> >I have a form that asks for Name, Job Title, Employee ID number, etc. I can
> > create a drop down list using Validate no problem. However, I want to be
> > able
> > to automatically populate the fields when a person's name is selected.
> >
> > For example, if I select Billy from the Name drop down list, the Job
> > Title,
> > ID Number, etc. gets automatically filled.
> >
> >
>
>
>