How to create a macro to copy and paste [Closed]

Report
Posts
1
Registration date
Wednesday July 12, 2017
Status
Member
Last seen
July 12, 2017
-
 Blocked Profile -
How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in column A. So in column C I would have the data from column A rows 1-18, then in column D I would have the next 18 numbers in column A.

2 replies


Open up the MACRO recorder, and record one. Then you can edit it, to change the hardcode stuff into variable to make it flexible. That is how I first learned VBA!
Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
220
Hello ac3mark,

Just for your info, the OP has received a solution here:-

http://www.ozgrid.com/forum/showthread.php?t=204801

Cheerio,
vcoolio.
Blocked Profile
That will work. go ahead and script kiddy the solution together, and never understand what you are doing! Right on!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!