Hey there,
I need to update a schedule based on a master. The master would get updated weekly so I want to have like a refresh button on a personal schedule so that it checks to see if the dates have change for tasks to be started and completed. The problem is that the master schedule, or database, is in different formating than the personal schedule. Attached I have given an example (There both in one workbook for convinience, usually they are in different workbooks). You can see that the "something" project has matching dates, but the "stuff" project has different dates. I would like to figure out how I can update the dates based on different tasks and add a comment with the previous value in the cell.
Bookmarks