Hi John,
I made 6 different Codes (Sale, Enroll, Change, Stop, Restart, Cancellation) and they work fine.
The only thing is if I have for example no "Change" in sheet "test1" and run the code, I get an error message "No cells were found"
I think this happens in the line with the "Auto filter".
Is there any chance that the code don't run the Auto filter and search for lines to delete if "Change" not exists?

Kind regards, Thorsten