Data Validation/Macro Problem

  • Thread starter Thread starter andyp161
  • Start date Start date
A

andyp161

Hi there,

In A2:A100 I have used data validation to insert drop downs of th
names of consultants. Is it possible to set up a macro so that when
consultant's name is selcted in column A, the same consultant's typ
will automatically selected in column B i.e. if Andrew is selected i
A2, New Business Consultant is automatically selected in B2 and s
forth??

Many thanks

And
 
Instead of a macro, set up a table, perhaps in another sheet:


A B
1 Andrew New Business Consultant
2 Lloyd Old Business Consultant
3 Harry Old Consultant
....

Then in your sheet with validation, use

B2: =IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,FALSE))
 
You must log in or register to reply 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

Similar Threads

Data Validation List (conditional) 2
Conditional Validation In Excel 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Macro for Creating Word Document!! 5
Error Message - Macro to Unlink MS Queries from Workbook 0
Lookup formula problemo 2
Using Data Validation List 1
Validation list driving macros 1

Back
Top