auto-sort for excel 2010

[ISSOWAVES]

Hello,

I'm making a task-list with excel 2010. I want the data I input into column B to auto-sort all column to E. So it will start with B finish with E.

As for the # of rows, it will start from row 2 and finish at row 35.

Is there a way to auto-sort this information whenever new data is inserted. We choose new data by the drop down menu in column B.

Any help will be greatly appreciated it.

 

[moooo]

I am talking about the first macro, not the second one.

 

[MichaelWDale]

Didn't want to create a new thread so I'll post in here. I'm wondering if anybody could help me:

I need column O to sort an array of numbers from largest to smallest when inputting data in the worksheet.
Then, I need the data in cell P2 to appear in cell H14.

If anybody knows the solution I will be so grateful. Thank you in advance.

 

[MichaelWDale]

Apologies for the double post but if anybody has the answer I'd grately appreciate it, trying to complete a long-term project and stuck on one of the final parts!