Previous Topic Next Topic

Macro - check name and then insert blank row

Closed
Miknas - Jan 26, 2011 at 10:20 AM
rizvisa1 Posts 4478 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!


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response