Why use a Macro? If you use Data Validation to create a dropdown list of
names, and next to this use a second column for the positions, then use =a1&"
is the "&a2
where a1 is the drop down cell for Name and a2 is a vlookup returning the
value of the position i.e. =vlookup(a1,rangeoflists,2,false)
Does this help


--
RWS


"white-ryland" wrote:

Can anyone advise how I can get a Macro to start when eg "David" is selected
from the drop down cell?

When eg David is selected from the list, I am wanting the Macro to run which
would insert text in another cell eg "January is the Store manager"

For Stewart the text would be altered slightly eg "Stewart is the Assistant
Manager"

Is this possible?

Help!

Thanks.