Hi,

I am interested if either of these solutions assisted you? I have the
same issue. I have tried both scripts but I am getting errors returned.
My VB skills are very rusty though. My columns a

Room No | Guest Name
1 | Mr Smith
5 | Miss Green
5 | Mr Brown
6 | Mr & Mrs Gray

Regards,

Gena


--
genas
------------------------------------------------------------------------
genas's Profile: http://www.excelforum.com/member.php...o&userid=35329
View this thread: http://www.excelforum.com/showthread...hreadid=550419