How to create a macro to copy and paste

Closed
johncarr1973 Posts 1 Registration date Wednesday July 12, 2017 Status Member Last seen July 12, 2017 - Updated on Jul 12, 2017 at 02:10 PM
 Blocked Profile - Jul 18, 2017 at 04:50 PM
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

Blocked Profile
Jul 14, 2017 at 09:18 AM
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!
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Jul 14, 2017 at 10:25 PM
Hello ac3mark,

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

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

Cheerio,
vcoolio.
0
Blocked Profile
Jul 18, 2017 at 04:50 PM
That will work. go ahead and script kiddy the solution together, and never understand what you are doing! Right on!
0