Hi all,
I want to make a "simple" maintenance plan that can do following tasks: to check when opened if the planned maintenance week has passed or is this week on sheet2 column BG, and if the maintenance to specific machine number was not done (columns BK, BM, BO and BQ) and display the results (machine number and planned week) as a list in sheet1. Also I want to create a checkbox in each populated row in sheet1 that, if is checked today, to fill in today's date to specific cell in sheet2 (columns BK, BM, BO and BQ). When saving and closing the file the rows in sheet1 should be deleted.
Could somebody help me. if possible?
PS. I don't know how to upload 2 images for explanation.!!
I want to make a "simple" maintenance plan that can do following tasks: to check when opened if the planned maintenance week has passed or is this week on sheet2 column BG, and if the maintenance to specific machine number was not done (columns BK, BM, BO and BQ) and display the results (machine number and planned week) as a list in sheet1. Also I want to create a checkbox in each populated row in sheet1 that, if is checked today, to fill in today's date to specific cell in sheet2 (columns BK, BM, BO and BQ). When saving and closing the file the rows in sheet1 should be deleted.
Could somebody help me. if possible?
PS. I don't know how to upload 2 images for explanation.!!
