Copy data into cells that are not in succession.

[NikkiG09]

Hello all,

I have 2 spreadsheets, Data and Template. I need to copy the info from Data into the appropriate cells in Template, the problem is the cells in the Template are not in succession. Can anyone help me with this?

Thanks!

[omahaNative_1023]

you can link the cells from one sheet to other. you can write code. you can copy multiple cells that not in succession and paste them to cells that are in succession yes, like this

Please Login or Register  to view this content.

but you can not paste cells not in succession to pasted cells that are also not in succession. so you can not do example like this

Please Login or Register  to view this content.

but yes, you can copy and paste cells from one sheet to any other one that open

[Gregb11]

Maybe something like this?

In cell A3 (In Template):

=OFFSET('[DATA (2).xlsx]wc_export'!A$2,(ROW()-3)/9,0)

Copy this across to E3
Then in A5, enter:
=OFFSET('[DATA (2).xlsx]wc_export'!F$2,(ROW()-3)/9,0)
and copy across to C5.

Then you can copy/paste these down. (You could actually copy from A3:E5 and paste to A12, then paste to A21, then A30, etc.