Macro to insert line and copy text from above

[PFDave]

Hi,

I'm waiting to receive the document itself but the idea is we have a row which contains information and in a column will have a number for how many times that needs to be repeated.

I need be able to run a macro and it will add in the number of rows below each entry but also copy and paste the information into those new rows.

So before Macro :

1 New Lane AB1 2CD 3
2 New Lane AB1 2CD 2

After

1 New Lane AB1 2CD 3
1 New Lane AB1 2CD 3
1 New Lane AB1 2CD 3
2 New Lane AB1 2CD 2
2 New Lane AB1 2CD 2

I understand the code will be column relevant which I don't have at the moment but I should be able to edit that myself.

Regards

Dave

[alansidman]

Look at this link

http://stackoverflow.com/questions/1...plicate-values

[PFDave]

Thanks for the link.

I have however started with this piece of code which works well, apart from the values of 1 are inserting a line also so I'm having to remove duplicates for these. Any idea what I need to tweak in the code? Anything 2 or greater inserts the correct number of rows.

Please Login or Register  to view this content.