I have once again reached the limit of my VBA knowledge and am here seeking help. Here's what I'd like to accomplish:
I have a worksheet list of projects, one project per row. I want Column B to be the 'Next Step By' date for each row. Users will be manually entering dates into Columns C, D, and E for each step of each project. There are different time intervals between each step, and I would like Column B to update based on input into each of these three columns in succession. When the first step is started, the next step of the project should be started within 10 days, then the next step within 30 days after that, then 60 days after that. For example:
The user starts a project and enters a date in a row in Column C, and the cell in Column B in that row displays the date 10 days in the future from that.
When the user then enters the next date in Column D, the cell in Column B then updates to display a new date that is 30 days in the future from the one entered in Column D.
When the user enters another date in Column E, then the cell in Column B updates yet again to display a date that is 60 days in the future from the one entered in Column E.
The idea is to create a sheet that is sortable by the 'Next Step By' date in order to easily keep track of which project needs attention first.
Is what I'm asking possible?
I have a worksheet list of projects, one project per row. I want Column B to be the 'Next Step By' date for each row. Users will be manually entering dates into Columns C, D, and E for each step of each project. There are different time intervals between each step, and I would like Column B to update based on input into each of these three columns in succession. When the first step is started, the next step of the project should be started within 10 days, then the next step within 30 days after that, then 60 days after that. For example:
The user starts a project and enters a date in a row in Column C, and the cell in Column B in that row displays the date 10 days in the future from that.
When the user then enters the next date in Column D, the cell in Column B then updates to display a new date that is 30 days in the future from the one entered in Column D.
When the user enters another date in Column E, then the cell in Column B updates yet again to display a date that is 60 days in the future from the one entered in Column E.
The idea is to create a sheet that is sortable by the 'Next Step By' date in order to easily keep track of which project needs attention first.
Is what I'm asking possible?