Copy a range of X number of cells then the next X number of cells and paste into sheet VBA

[drop05]

Hello, I am curious if this is possible. I have a certain range of cells in a column id like to copy the values from, say column G i have 100 rows i want to go through copy the values from the cells and then after that 100 do the next 100 rows and keep going until the last value on that row. Starting at G7. Is there some kind of for loop for this? in my mind i was thinking of a for I = # to # kinda thing. But a bit new to VBA
Thank you.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).