Hello,
Yes both columns are sorted alphabetically, but the list on the right side
gets name added into it (few at a time) and also looses some compared to the
list on the left... Thats the reason I need the macro... I have other
information located in adjacent cells which can easily be formatted once
these listslign up, and have blank spot where name are missing...

"Executor" wrote:

Hi TroyT,

I asummed that both colmuns were sorted.
If they are not, there has more to be done.
I will look some more into it ASAP.

Executor