Auto sort??

[falseadvertise]

I am trying to figure out a way to sort a worksheet based on values in two columns. I have columns A-G and rows 5-29 (although i will need to expand on the 29 at some point). The rows need to stay complete so the descriptions and other inputs are not lost.

Columns E and F are the values i want to sort by. they are a range between 0 and 5 (5 being more severe). I want it to sort highest to lowest based on the sum of the inputs in E and F with row E holding more significance. For example, if i have points 3,5 - 3,3 - 5,3 and 4,5 i want to auto sort them as follows: 4,5 - 5,3 - 3,5 - 3,3. Also, i would like to be able to change the values in E and F and have it update the sort automatically.

It is important that my rows stay in tact.

Any ideas?

-Thank you!

 

[borgem]

Private Sub Worksheet_Change(ByVal Target As Range) Worksheets("Worksheet Name Here").Activate
Range("Your Data Range Here").Select
Selection.AutoFilter Field:=3, Criteria1:="<>" End Sub
</pre>