I've created a spreadsheet that I copy and paste information with people's
last name and first name. I've created a table where I've recreated the list
so they are first name, space and then last name. I need to sort the table
into alphabetical order based on the first name. Using the Sort function
doesn't change the order from what they what they were first created. What
I'd like to do is build a function into the spreadsheet so that the table is
automatically sorted after I copy and paste the list into the worksheet. Is
this possible and can you show me how to do it?