Need some help with this one.
I am trying to get a worksheet to automatically re-sort after opening or changing data.
Column A is a list of names
Column B is a senority ranking
Column C = Auto sum of Columns D-X

I have a sort function to sort by Col C then by Col B
I need the spreadsheet to automatically update the sorting when new data is entered in columns D-X.

I know I need a macro to do this, but I am not familiar how to set one up. I am using Microsoft 2007 right now.
PLEASE HELP!!