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