Ok, so I have a ream of measurement results (over 500), which need to be sorted into a results table. This table is a collection groups of fifteen results (three columns of 5), 36 in total. So the current method is to go through by hand copy and pasting each group of 5 into the right part over and over 36*3 times - VERY time consuming, clearly. I am tryign to make a macro to speed this up, and am wondering if I can get VBA to automatically increment the values?

Example:
Range("A1:A5").Select
Selection.Cut
Sheets("TABLE 2").Select
Range("B5:B9").Select
That is the first one, the next should be:
Range("A6:A10").Select
Selection.Cut
Sheets("TABLE 2").Select
Range("C5:C9").Select
After one more shift sideways, it then goes DOWN to:
Range("A16:A20").Select
Selection.Cut
Sheets("TABLE 2").Select
Range("B12:B16").Select

Clearly I can just go through doing it myself, but I have a LOT of macros doing similar jobs to make (I am working on replacing two guys about to retire in this department and don't want to waste my time on the amount of manual work with excel they do!), and I would find an automatic solution SO much easier.

I have thought of one possible solution (if there isn't an in-built command), but don't have the knowledge of VBA to implement it - use 'Range("Ax:Ay").Select' where 'x' and 'y' are subjected to an increment somehow. No idea if that's possible for various reasons.!

Any tips would be great - apologies if this has been covered before, but I couldn't find it...

Cheers, Rohan