Insert 2 rows between specific numbers in Col A

**flupsie** · 07-04-2018, 10:14 PM

I have tried to write code to insert 2 rows in Col A at the start of the each number in the column beginning with 153, 163, 173 & 193.

In the attached sample data, the raw data is in sheet1 and the result onn sheet "Manual result" to show you what the final outcome should look like

The following code is highlighted in red

Please Login or Register  to view this content.

See my full code below

Please Login or Register  to view this content.

Your assistance in this regard is most appreciated

I have also posted on the link below yesterday

https://www.mrexcel.com/forum/excel-...in-number.html

**BadlySpelledBuoy** · 07-04-2018, 11:56 PM

What happens if the number does not begin with one of those 4 options?

BSB

**flupsie** · 07-05-2018, 12:00 AM

If it does not begin with the 4 options, then it must be ignored i.e no rows to be inserted for any other numbers. There is a small likelihood of this happening though

**jolivanes** · 07-05-2018, 12:07 AM

Same result as in your attachment.

Please Login or Register  to view this content.

**flupsie** · 07-05-2018, 12:34 AM

Thanks for the help, much appreciated

**jolivanes** · 07-05-2018, 12:47 AM

You're welcome.
Good Luck

**jolivanes** · 07-05-2018, 02:01 AM

More in line with the "Always delete rows from the bottom up"

Please Login or Register  to view this content.

**flupsie** · 07-05-2018, 02:58 AM

thanks for the updated code

**BadlySpelledBuoy** · 07-05-2018, 03:17 AM

It still doesn't take care of entries that do not fit the 4 options.

Try this slightly amended version of jolivanes' code:

Please Login or Register  to view this content.

BSB

**jindon** · 07-05-2018, 04:29 AM

Please Login or Register  to view this content.

**flupsie** · 07-05-2018, 04:31 AM

Thanks for your help, Guys

**AZ-XL** · 07-05-2018, 06:28 AM

Hi

and here VBA novice solution

Please Login or Register  to view this content.

**flupsie** · 07-08-2018, 08:53 AM

Thanks for your code AZ-XL

Insert 2 rows between specific numbers in Col A

LinkBack

Thread Tools

Rate This Thread

Display

Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Re: Insert 2 rows between specific numbers in Col A

Thread Information

Users Browsing this Thread

Similar Threads

Insert multiple rows each specific number of rows

[SOLVED] Insert multiple rows each specific number of rows

[SOLVED] Macro to insert specific number of rows, populate rows with data above except date

[SOLVED] Insert row numbers into column A, reflect correct row numbers when I add or delete rows

Insert 0 into specific column and specific rows

[SOLVED] Insert Rows on Criteria and Copy content to Specific Cells in New Rows(Tables)

Insert/Delete rows based on the same numbers of rows with data in other sheet

Bookmarks

Bookmarks

Posting Permissions