Excel_User18
New Member
- Joined
- Sep 4, 2018
- Messages
- 4
I have an Excel workbook that I copied from Project and formatted based on the Project file. I have inserted a picture below of my Excel workbook. I grouped the rows by their outline level in order for the grouping to match the summary and sub-tasks format in Project. I was wondering if their was a macro I could run that could automatically update the Start and Finish dates (columns E and F below) of summary tasks based on change to those dates in their sub-tasks (as is done in Project). For instance, if I changed the Finish date of "Project Plan Finalized," the Finish date of "Analyze" and "Phase 1" would be automatically updated; I'd like to obviously do the same for Start date too. If anyone has a macro that could update those dates automatically, that would be amazing!