I want to create a copy from sheet1 and paste into sheet2 in excel with macros. My question is it is for a label sheet. The label sheet has ten labels (rows) down and three columns across. Is there a way I can create a code so the computer knows to paste in this order?
I am coping three columns in the same row and pasting them into a different sheet.
I would need it to look for the first open slot and paste the three cells in something like below.

ABC DEF HIJ
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333
111 222 333

Or it could paste across first and not down.....
Any help would be greatly appreciated.