Hello any help given is much appreciated I am quite new to Macros and VBA
I am trying to modify a scheduling spreadsheet for Time Based Maintenance, the sheet has a list of TBMs and the frequency they need to be done (Weekly, monthly, yearly etc) and the next due date they need to be planned for and the status 1= completed 0 or blank=not completed.
I need to be able to type a date in the due date cell so it is static but i want it to automatically change the date when the status cell is changed to 1 by either 1 month, 6 months, 1 year depending on what is set in the frequency column for that row if it is set to monthly and i put the status to 1 it will adjust the date by 1 month same for yearly and 6 monthly,
<tbody>
</tbody>
Once the status is changed to 1 and the date is reset the status then needs to revert back to blank or 0.
Cheers
I am trying to modify a scheduling spreadsheet for Time Based Maintenance, the sheet has a list of TBMs and the frequency they need to be done (Weekly, monthly, yearly etc) and the next due date they need to be planned for and the status 1= completed 0 or blank=not completed.
I need to be able to type a date in the due date cell so it is static but i want it to automatically change the date when the status cell is changed to 1 by either 1 month, 6 months, 1 year depending on what is set in the frequency column for that row if it is set to monthly and i put the status to 1 it will adjust the date by 1 month same for yearly and 6 monthly,
A | B | C | D | |
1 | Action | Frequency | status | Due Date |
2 | Conveyor 1 Service | Annual | 0 | 1 Sep 17 |
3 | Conveyor 2 Service | Monthly | 0 | 1 Sep17 |
4 | Conveyor 3 Service | Monthly | 1 | 1 Oct 17 |
<tbody>
</tbody>
Once the status is changed to 1 and the date is reset the status then needs to revert back to blank or 0.
Cheers