Sorting multiple columns issue

Hello forum,

I have ran into an issue that seems very simple but...

Trying to record a macro to Sort multiple columns (A-N) based on column D ($PH)

Im doing everything correctly, highlight entire range and sort column D values A-Z... But the results are giving me the smallest $PH first, i need the largest to smallest.

Anyone know what im doing wrong?

I ran into this problem on a previous workbook and a great forum member helped write VBA, but i have no idea how to apply to new workbook as columns are different and a cpl different actions are taken. i Remember what we had to do tho was have VBA sort by hours, then sort $PH down to first empty cell.... im thinking their has to ne an easier way tho

Any help/advice is greatly appreciated!