Why not add a command button to the sheet, so you can sort on demand?

Then just record a macro of yourself sorting on whatever field you
want, and attach the code to the button. It will re-sort every time
you click.


HTH
--JP


On Oct 7, 1:50*pm, FVO wrote:
Hi;
I need to create a worksheet to keep record of customers.
I have the following example:
NAME * * PHONE * * ADDRESS * * CONTRACT * * WK1 * * WK2
Phil * * * *123-456 *
Angel * * 321-654
John * * *987-630

I need to keep the first row as the titles row, and need the worksheet *to
automatically sort in alphabetical order based on the name, and to do it
everytime a new customer is added to the list.

HOW CAN I DO THAT?

Regards,
FVO