Previous Topic Next Topic

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 responses

Answer 1 / 2
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!
Answer 2 / 2
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Contributor Last seen September 6, 2024 262
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.
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!

Similar discussions

How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
VBA code to create Pivot Table
sarisri7 -
ac3mark -

1 response