![]() |
Copy and Pasting with Macros
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. |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com