Copy row based on criteria & clean up record

[nnaidoo1972]

Please can someone assist with a macro to do the following:
1. Copy a row n number of times based on the data in column E. In the example attached, search for ";#". In this case, you need to copy row number 25 3 times.
You now should have 4 rows with exactly the same data.

2. Clean up the data in column E to have unique values with the rows just copied ie. in the example attached, one should end up with:-
"Bank account less than 6 months old" in row number 25
"Bank account not verified" in row number 26
"case not rerouted" in row number 27
"Case not spawned" in row number 28

Thanks
Neil

[gjlindn]

if you're not concerned about the rows being next to each other, this should work

Please Login or Register  to view this content.

[gjlindn]

If you do have data following the row(s) you're fixing and want to keep the new rows all together, this code would be better

Please Login or Register  to view this content.

[gjlindn]

One more modification...This one keeps them in the same order they were originally listed in.

Please Login or Register  to view this content.