Changes to lookup data to only affect ROWs with todays date or greater instead of all data

NB You could put your "Rota" in a table and use qualified table references instead of hard-coding the ranges. Then the data could change without messing up the VBA.