Previous Topic Next Topic

Excel macro to insert two rows.

Closed
VIVIANNA TORA JESON - Updated on Nov 12, 2017 at 12:44 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 12, 2017 at 12:48 AM
Hello,





I have similar problem as this. Just that, I wanted to insert row in different categories. Examples as below:


Date Trials ID
01.01.2011 1 A
01.01.2011 1 A
02.04.2011 1 B
02.04.2011 1 B
01.02.2011 1 C
01.03.2011 1 C

How can I insert 2 rows after different ID?

I wanted it to be like this:

Date Trials ID
01.01.2011 1 A
01.01.2011 1 A


02.04.2011 1 B
02.04.2011 1 B


01.02.2011 1 C
01.03.2011 1 C


May you help me with this? Thanks in advance =)

1 response

Answer 1 / 1
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Nov 12, 2017 at 12:48 AM
Hello Vivianna,

Have a look at this previous thread:-

https://ccm.net/forum/affich-908048-macro-for-inserting-multiple-rows-between-data

In the code supplied by TrowaD, you may only have to change the 2 to a 4, change the Resize(45) to Resize(2) and the 46 to a 4.

I hope that this helps.

Cheerio,
vcoolio.
0