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.