Auto Sort

[Rob04]

I have a chart that the range is A9:AR25 with the headings being in ro
8(A8:AR8). I am trying to find out how I can have this char
automatically sort the data when a new value is entered, sort first b
column AR, if tied then by column AI and finally if still tied b
column AO

 

[Don Guillett]

record a macro of your sort and then place within a worksheet change event
in the sheet module

 

[Rob04]

Not really sure how to do that. Will that automatically sort the char
as soon as on cell is changed in one of those columns