Hi Keebellah

Really nice code there, I love it. The only thing is if there is 2 weeks selected it wont copy the job into both those sheets. So if there is Monday and weeks 1 & 3 selected it wont copy the job to either sheet.

The only reason I had the clear in the code was because I didn't want to double up the Jobs on each sheet when we run the Create Jobs button again. What we would like is for the Create Jobs button is to not have duplicates, but also keep older records of the same job (e.g. changing something from weeks 1 & 3 to 2 & 4 the 1 & 3 records would stay in the sheets but not in the backlog because we have changed it.)

So we were thinking that when we run the create jobs again the code would know that the same jobs existed and not to copy them again and to only copy the changes. This will be good when changing the Jobs mid month.

Thank you