Data Validation

S

Stephen Lynch

Is it possible to show the values in column B&C, but post the value in
column A when using Data Validation.

For example, Column B has Last Name, Column C has First Name, Column A has
Social Security Number.

The person clicks the combo box, the list shows Last Name, First name sorted
decending. He selects a name and the SS# shows up in the field.

The worksheet that will have the list of employees is entitled "Employees".

Thanks

Just starting here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top