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