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!
Bookmarks