Hello,
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) and have created a drop down list at cell I7 (which is merged to W7).
I've added the budgeted days next to the list (in column D) and would like a macro that put's the budgeted days into the form (cell G30) once the project has been selected from the drop down list.
Is there a way for this to happen??
Thanks in advance,
Jen
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) and have created a drop down list at cell I7 (which is merged to W7).
I've added the budgeted days next to the list (in column D) and would like a macro that put's the budgeted days into the form (cell G30) once the project has been selected from the drop down list.
Is there a way for this to happen??
Thanks in advance,
Jen