Macro/VBA code to duplicate every N-th row, N times

**ushbar** · 10-28-2020, 05:52 AM

Hi,
*
I'm a newbie to VBA and macro so I need help with a script/code that can duplicate every 17th row, four number of times. This should be a loop.
*
I have attached a part of my dataset. I want to duplicate every 17th row because I have a new 'Id' after every 17th row.*

**Kaper** · 10-28-2020, 06:35 AM

Hi, VBA hardly can work on the image. Please consider attaching a sample workbook not a screenshot (see yellow banner near the top).

As a general rule: in such case it's usually good idea to use reversed loop so assuming your last x * 17 is filled it could go like that:

Please Login or Register  to view this content.

Macro/VBA code to duplicate every N-th row, N times

LinkBack

Thread Tools

Rate This Thread

Display

Macro/VBA code to duplicate every N-th row, N times

Re: Macro/VBA code to duplicate every N-th row, N times

Thread Information

Users Browsing this Thread

Similar Threads

Macro to make every row duplicate 10 times

[SOLVED] Need Macro to search for duplicate times across many tabs in a spreadsheet

how to used macro code to record data which change over the times

Macro for running the SQL code multiple times

I need a macro that will let me loop a section of the vba code x number of times

[SOLVED] Need a Macro that will duplicate rows a number of times based on a column value

macro to delete entire row of duplicate dates and times dd/mm/yyyy hh:mm:ss

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions