Hello!
I have a spreadsheet (attached) that has a "Project Build" tab and a "Template" tab. The "Project Build" tab has a list of typical project tasks in Column B, and a series of Check Boxes in Column A (beginning with Check Box 1). I would like to have a macro that will create a new tab (which is a copy of the "Template" tab) with the Project Number as the name, list the project tasks in Column E that were indicated by the user checking a box, and change Column N to "In Progress" for each row that has a task on the new sheet.
If possible, I would also like the project to get listed in the "Project Directory" tab and then have the "Project Build" tab reset after the macro has been run (I will use a command button to run the Macro).
Thank you very much for any help!
New Project Build.xlsm
Bookmarks