Automatic Sorting Function?

[Scott B. Hogle]

Is there a way for Excel to automatically sort a column?

I know that I can manually sort the column with the Data -
Sort process, but I was hoping that there was a way that
it could be done automatically.

I will be cutting and pasting data into Excel and it
would make it much easier to train the end user if I
didn't have to have them manually sort the data.

Thanks in advance for your help.


SBH

 

[Frank Kabel]

Hi
the only way would be to use an event procedure (e.g. the
worksheet_change event) and sort the data within this procedure.