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
Bookmarks