Report

Excel macro to insert two rows.

Ask a question VIVIANNA TORA JESON - Last answered on Nov 12, 2017 at 12:48 AM by vcoolio
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 =)
Helpful
+0
plus moins
Hello Vivianna,

Have a look at this previous thread:-

http://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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!