VBA to sort a worksheet by last name

[thedunna]

Greetings, I am trying to find a way to instantly short my worksheet. I have a worksheet with data that spans from column A to column T and it continues down to row 525. After the header, the data begins in row 3. The next 325 rows currently have data. I begin entering new names with data at the bottom of the list on a regular basis. When I am done entering the new names, I hope to be able to instantly integrate them into the list alphabetically. Column C is the last name of the person. Is there a way to create a VBA button to do this? Thanks in advance for any help that can be provided.

[LeoTaxi]

Just select any header to sort

Please Login or Register  to view this content.

Kind regards
Leo

[thedunna]

Leo, thank you very, very much. This was beyond expectations. I was originally looking for a command button that would sort by only one criteria (Last Name) A-Z. This works great though and thanks again.

[thedunna]

Leo, you were a tremendous help to me with this sorting issue. I can't thank you enough. I have used it ever since and it works beautifully. I am trying to figure out a way to tweak the sorting function that might work better for me but cannot find a way. I am hoping you can help.

Using the same sample worksheet, what I would like to do is always sort column A first, then sort by whatever column header I choose. That way the 1's, 2's, 3's, etc... would be sorted first. I am hoping anyone with an "x" in column A would fall to the bottom of the list followed by any blank in column A. I hope this makes some sort of sense. In other words, if I were sorting data manually, I could select two levels of criteria under the sort function. Can this be done with VBA? Thanks for any consideration you can give to this.

[nigelog]

Would have been easier start a new thread as this one marked as solved but change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[thedunna]

Thank you.