Most valuable professional
  • Hot Topics

Excel Copy every 6th row and insert/paste underneath. Duplicate every 6th row on same sheet.

Hello, I need a Macro to copy every 6th row (starting at 1) and insert underneath said row. It would look something like this: 1 Black 2 Blue 3 Gold 4 Green 5 Orange 6 Red 7 Black 8 Blue 9 Gold 10 Green 11 Orange 12 Red Needs to be: 1 Black 1 Black 2 Blue 3 Gold 4 Green 5 Orange 6 Red 7 Black 7 Black 8 Blue

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 22, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel