Macro - check name and then insert blank row

Closed
Miknas - 26 Jan 2011 à 10:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 27 Jan 2011 à 09:09
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!


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
27 Jan 2011 à 09:09
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