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

--
Message posted from http://www.ExcelForum.com

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))





In article ,
andyp161 wrote:

Hi there,

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