How was this auto-update done?
May I view the code so that I can make sure it doesn't interfere with it?

In what order is the data sorted? Provide an example.

and finally, if you can attach your workbook or dummy workbook so that we have easier time understanding which column you are trying to sort in what ways and such.