I have a workbook for each month. Each worksheet gives information for each
day in the month. I have a list of parts and have a calculation on each
sheet which is totalled on a final sheet in the workbook. When the machine
parts get to a certain amount a message pops up beside that part saying the
part needs to be serviced. The problem I have is that after that message
pops up I need to be able to clear the total and start again from the next
day on the sheet.