Hello,
I am attempting to create a programme that allows me to enter customer information on a main page and like name, address and contact details. When completed I would like a macro to transfer it over to another worksheet. As the list grows I was trying to place it in alphabetical order based on surname.

I was trying to upload a page but cant seem to get it to save.


SURNAME FORENAME ADDRESS EMAIL TELEPHONE


Its basically as above only there are four lines in the address box.

Thank you in advance.

Colin.