ok So I have a workbook and it continues to grow but each sheet is copied from a master sheet, and then that day's data is entered. I have almost everything set to be perfect but now I need column J &K to sort automatically upon update of a number in J (which automatically updates). I need it to sort k2-42 by descending value and keep the value of j with its matching k row. and then I need it to sort by j Alphabetically. by the way this is excel 2010
example :
J K
south bend 5
Niles 0
Mat 3
Adon 3
needed to do automatically:
J K
South Bend 5
Adon 3
Mat 3
Niles 0
I would like to paste this macro into the entire workbook so that when a new sheet is created it automatically gets the macro.
Help please
example :
J K
south bend 5
Niles 0
Mat 3
Adon 3
needed to do automatically:
J K
South Bend 5
Adon 3
Mat 3
Niles 0
I would like to paste this macro into the entire workbook so that when a new sheet is created it automatically gets the macro.
Help please
