Macro to copy a range of columns in different rows

[Nahmed212001]

Hello all,

I'm trying to create a macro to:

1. copy a range of columns (G thru O) but the data is in different rows on different spreadsheets.
2. then paste the data on one spreadsheet but different rows. The data will be placed on the same columns.

Thanks in advance.

 

[machopicho]

Hello all,

I'm trying to create a macro to:

1. copy a range of columns (G thru O) but the data is in different rows on different spreadsheets.
2. then paste the data on one spreadsheet but different rows. The data will be placed on the same columns.

Thanks in advance.

Make an example please!