Hi Solus,

Thank you so much for the quick reply. I have put this code in but it does not seem to work. Is there a specific format that I need to type for the dates to work? There is also seems to be an error in the line .Range(Cells(rng1.Row, "AA"), Cells(rng2.Row, "AD")).Copy

thank you so much for your time!