Sort and Remove Duplicates

Hi there,

Try the following code and see if it does what you require. You'll notice that I've put "all the stuff with double-quotes" at the start in order to make it easier to adapt the code for different worksheet names / worksheet layouts etc.

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks I was having trouble with this before but you have helped me tremendously!

Hi again,

Many thanks for your feedback - I'm glad you found my suggestion helpful.

Best regards,

Greg M