How to create a macro to copy and paste

Closed
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
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
243
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!