I need a macro that will take a list and sort by last name (B:B) with the
first row of data being row 3. The user will be adding names at the end of
the list and then press a command button to sort in ascending order. I know
xlUp needs to be used but not sure how to place it in the code. The column
range is A:N. Column headers are in row 2.

Thanks,
Les