auto sort a table whenever new data is entered

[touque]

I have a sports pool set up and I'd like to set up the standings table to sort automatically whenever new data is added. The data is entered automatically via a web query that updates every 2minutes. can this be done?

 

[mole999]

add your sort routine to the end of your import routine,

might want to surround it with

application.enableevents = false
code
application.enableevents = true