Hi Solus

The pasted data is from another macro, but to answer your questions, the amount if loops is the difference between the two entered weeks 1 and 5 plus 1. So if the user enters 1 and 5 then the loop would be five and the weeks to be pasted are 1 through to 5. Same if they entered 49 and 52, the loop would be 4 with the weeks 49 through to 52 next to each pasted block of data

Thanks