Two parts to this I'm afraid ....
I have a sheet that ranges A to S and down. When another sheet updates I
have a formula running to auto update columns A & B with Last Name & First
name which works well - I want to have the sheet auto sort each time it is
opened by column A -
1. How do I do this please
2. Can I make it only sort when there are names in the cells rather than
including the formulas which at this point show as 0 until updated beacuse at
this point when sorted the 0's all go to the top??

Assistance as always appreciated.
--
Thanks

Lise