Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate fields | Excel Discussion (Misc queries) | |||
Auto Populating cells from a master spreadsheet | Excel Discussion (Misc queries) | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |