Multi criteria sorting

[Av8tordude]

Is it possible to sort a table by Date & Item. In AV11:AZ500, when i enter an expense, it sorts by date, but also I would like to sort by Item.

Example:

1/2/10 Clothes
5/2/10 Clothes

3/20/10 Dry Cleaning
4/23/10 Dry Cleaning

 

[GlennUK]

Do you get what you want when you sort by Item as the first sort field, and Date as your second sort field?

 

[Av8tordude]

I know how to sort by item. This sorts by date...

Range("AV11:AZ500").Sort Key1:=Range("AV11"), Order1:=xlAscending, Header:=xlNo

But how do I get it to sort by item also?

 

[GlennUK]

Use Key2 also.

 

[Av8tordude]

Is this correct?

Range("AV11:AZ500").Sort Key1:=Range("AV11"), Order1:=xlAscending, Header:=xlNo, Key2:=Range("AY11"), Order2:=xlAscending, Header:=xlNo

or

Range("AV11:AZ500").Sort Key1:=Range("AV11"), Key2:=Range("AY11"),Order1:=xlAscending, Header:=xlNo

 

[GlennUK]

Your first guess looks closer, although maybe you shouldn't have Header in there twice.