If i manually enter overtime hours worked in column A it will auto sort lowest to highest like the VBA code is written (or in my case, copied), but what i want to do is in A2 put the formula =SUM(E2:AM2) and have it auto sort by the sum in A2 and not by me entering it manually in A2. I then want to copy the formula as i add employee names. I have tried what i described above but it will not work for me, any help will much appreciated.
Bookmarks