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.

 

[Domenic]

Try the following code which needs to be placed in the sheet module (right-click the sheet tab, and select 'View Code')...

[font=Verdana][color=darkblue]Private[/color] [color=darkblue]Sub[/color] Worksheet_Change([color=darkblue]ByVal[/color] Target [color=darkblue]As[/color] Range)
    [color=darkblue]If[/color] Intersect(Target, Range("B2:B35")) [color=darkblue]Is[/color] [color=darkblue]Nothing[/color] [color=darkblue]Then[/color] [color=darkblue]Exit[/color] [color=darkblue]Sub[/color]
    [color=darkblue]With[/color] Range("B2:E35")
        .Sort key1:=Range("B2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, _
            MatchCase:=False, Orientation:=xlTopToBottom
    [color=darkblue]End[/color] [color=darkblue]With[/color]
[color=darkblue]End[/color] [color=darkblue]Sub[/color]
[/font]

 

[ISSOWAVES]

hi Domenic

Yes! it worked. Thanks very much for your help.

One other thing, I have two task list on one sheet. The code you provided works for the first task list, but I hope it can also work for the second task list.

The other task list is at located at:
column G:J
row 2:35

 

[VoG]

This is a duplicate of http://www.mrexcel.com/forum/showthread.php?t=577659

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.

 

[ISSOWAVES]

i had trouble posting this, which is why i accidentally posted it twice. i couldn't figure out how to delete it.

 

[VoG]

OK, there was a problem with the board yesterday which might explain that.

For future reference you cannot delete your posts but you can click the Report button to request the moderators to remove a duplicate thread or post.