I currently have a macro that copies a sheet to a different workbook
dependant on who the adviser is. It currently picks the adviser name up from
a cell in a sheet, but what I would like it to do is then when the macro is
set off, some kind of input box comes up and gives the option of which
adviser name to choose (be it a dropdown menu, a tick box etc)

Anyone know how to do this?

Cheers,

cdb