VBA loop? to copy/stack 5-25 columns from 1 tab to another

[dsheridan]

I'm tryin to copy data from Spreadsheet 1 to Spreadsheet 2.
All of my data that I'm copying starts at row 7 except for the GL account value.


Col A (cost center), Col F (Project) Col's G to ? are dollar amounts. Some sites may only have 2-5 columns, others up to 30 columns starting at G. G6 to ?6 has the account #. G4 to ?4 will either say "proj" or "inf" so I'd only want to do copy/paste for the data under the "proj" columns.


I want to copy the following info to Spreadsheet 2 starting at row 3.
Col A to Col A,

Col F to Col H

G6- autofill to Col K

Col G7-G(end) to Col I

Columns A and F should be constant, so after column G, I'd want it to look at Col H (or the next "proj" column) on spreadsheet 1.

The pasting on spreadsheet 2 should be at the bottom of the first pasted section. So if I copied 20 rows to Sheet 2 above, then when going to the data in Column H:

Col A to Col A
Col F to Col H
H6- autofill to Col K
Col H7-H(end) to Col I.

would be pasted underneath the pasted data (i.e. starting at row 23). and so on- Col A to A, Col F to H, I6 autofill to K and I7:I(end) to col I, etc

Any help would be greatly appreciated!