Hello Pros,

I got a VBA book, I got one, I wont be asking as much!!! Just one more.

At the moment I have a vba that copy and paste values which will change as
future weeks come about. But for this week its range AU7 to AW14. this
range at the moment is copied and the pasted in specific ranges I've placed
in the VBA, but the report is still evolving, new rows with different data
are being added, so every time I add a row, I have to change the row range
about 150 times. Is there a way, since the report has a specific format,
where it can just paste this initial copied pasgte of AU7:AW14 every 18 rows,
so if I add new rows, all I have to do is change the row count on the VBA,
not as difficult. Hope you understand and could help guys.

Regards,