yogi_Set Up To Automatically Sort Data By Priority And Time Taken Columns In Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user praber31 said:
I have a spreadsheet that has 5 columns. Task, Next Step, Time Guess, Time Taken, Priority.

Time Guess is in minutes and Priority is A,B,C,& W. 

I would to have it auto update my form based on Priority (A-Z) and then Time Guess (A-Z). This way the top of the list would always have the highest priority that can be completed in what I think is the shortest amount of time. This spreadsheet would then auto sort when I change the next step's time or priority.

Any help would be appreciated. 

-------------------------------------------------------

following is a solution to the problem: