J
jt24152
I want to create a copy from sheet1 and paste into sheet2 in excel wit
macros. My question is it is for a label sheet. The label sheet has te
labels (rows) down and three columns across. Is there a way I can creat
a code so the computer knows to paste in this order?
I am coping three columns in the same row and pasting them into
different sheet.
I would need it to look for the first open slot and paste the thre
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
macros. My question is it is for a label sheet. The label sheet has te
labels (rows) down and three columns across. Is there a way I can creat
a code so the computer knows to paste in this order?
I am coping three columns in the same row and pasting them into
different sheet.
I would need it to look for the first open slot and paste the thre
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