I have attached a short link to a video to explain my problem
I'm at my wits end but Im sure this is a doddle for you.
Thanks for your help.
I've only recently begun to use Macro's so please forgive my ignorance!
I've created a form for users to advise a project is to begin - Cleverly named the "Project Commencement Advice" form.
I've created and named a list of all of the projects scheduled for the year (cells C69:C158)...