JP;

You and Jim have the same opinion and it seems to be the best. I'm very
novice with excell. Could you (or Jim) help on that Command Buttom and adding
the MACRO to it? THANKS!!

FVO

"JP" wrote:

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