Excel macro to insert two rows.

[Closed]
Report
-
Posts
1313
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 3, 2021
-
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 reply

Posts
1313
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 3, 2021
233
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!