Moving Groups of 7 Cols to 1 Group of 7 Cols

[hammer2]

Hi Folks
On a daily basis I have to copy and paste several groups of 7 Cols into 1 group of 7 cols.

First group is A:G then H:N etc

Is it possible to automate something that can grab each group of 7 and paste into the next blank row in A:G ?

Cheers
hammer

[GC Excel]

Hello hammer2,

Going blindly without seeing your file. This should get you started...

Please Login or Register  to view this content.

[hammer2]

Thanks GC
I have attached a workbook.
It is exactly how the data appears.
It is the next 4 groups (color coded) that I want placed onto the end of the first group.
The amount of rows will vary with each new lot brought in.
Cheers
hammer

[jindon]

This should do

Please Login or Register  to view this content.

[hammer2]

Fantastic!
Thanks so much for your time folks!