Automatic Sorting Function?

  • Thread starter Thread starter Scott B. Hogle
  • Start date Start date
S

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
 
Hi
the only way would be to use an event procedure (e.g. the
worksheet_change event) and sort the data within this procedure.
 
Back
Top