turbodante

Hi Turbo, I saw a post regarding auto sort in Excel. I attempted to follow your instructions for newbie, but I couldn't make it work. Slurpee attempted to help, but referred me back to you. I hear your the expert. In short, I have a 7 column spreadsheet with names in the first column. I am creating it for someone who knows nothing about Excel; therefore, I need it to sort automatically when she enters the name of the person. Will you explain step-by-step how I can do that?

thanks turbodante, just received your message, when you say it needs to go in the sheets code ????? also the range's and sheet number i.e. g7, h7, sheet1 i take it these are examples and i use my own range's, sorry to be so stupid, lol.

Thanks, we got there in the end.