Sort names NEWBIE

[JLandrum]

Attached: How can I make a column automatically sort by last name (1st column) that contains first an last name and have D.O.H (3rd column) info stay with the name. A command button would also work for me, just not sure how to do it. Thank you

[Yongle]

Names are easier to sort if you have one column for First Name and a different column for Last Name.
(Possible then sort first by Last Name followed by first name)


Use standard Excel functionality to put values in adjacent columns as follows:
If Peter Smith is in cell A3
=LEFT(A3,FIND(" ",A3,1)-1) returns value Peter
=RIGHT(A3,LEN(A3)-FIND(" ",A3,1)) returns value Smith
(beware - this works only in cases with one first name)


If it is not easy to modify worksheet structure, then input the names differently
Instead of Peter Smith, input as Smith,Peter
which will allow you to sort by the last name (and will automatically second sort on first name)

I have had a look at your workbook - column A only contains First Names

[JLandrum]

Thanks for the help, I made 2 columns, first and last names. How can I have VBA automatically sort the names when names are input. Thanks again

[Yongle]

I assume you want to sort first by Last Name and then by First Name
See attached file. Click on the button and see what happens.
I unmerged cells within data sort range - one of the merged cells was causing a problem
The macro is called SortBySurname - you will need to adapt to suit your column numbers and range

[JLandrum]

That's great, works perfect. Thank again