I have a macro designed to move a sheet to a different workbook dependant on
who the adviser is. At the moment I have this looking at a certain cell in a
workbook. What I would really like is when the macro is set off an input box
pops up and gives the options of adviser names to choose from.

If this possible, and if so how?

Cheers,

cdb