Macro - check name and then insert blank row

Closed
Miknas - Jan 26, 2011 at 10:20 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 09:09 AM
Hello,

Would appreciate any help on below.

I need a macro that would insert a blank row after each unique entry.

To illustrate imagine following data:

John
John
John
Chris
Chris
Joe


I want macro to automatically insert a row after 'last' John, last Chris and Joe.


Would very much appreciate any response.

Thanks!


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 27, 2011 at 09:09 AM
loop bottom up. Compare the cell value with the last value. If value change insert a blank for else keep on looping up and up
0