Sort based on column values then repeat

[jrf1111]

Hi all, I have a worksheet that looks something like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person#[/TD]
[TD]Stuff #[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]1[/TD]
[TD]Person1 stuff 1[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]2[/TD]
[TD]Person1 stuff 2 [/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]2[/TD]
[TD]Person2 stuff 2[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]4[/TD]
[TD]Person2 stuff 4 [/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]3[/TD]
[TD]Person2 stuff 3 [/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]1[/TD]
[TD]Person2 stuff 1 [/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]2[/TD]
[TD]Person3 stuff 2 [/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]1[/TD]
[TD]Person3 stuff 1[/TD]
[/TR]
</tbody>[/TABLE]

For some reason Excel won't sort first by Col A (Person #) then by Col B (Stuff #) so it will look like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person#[/TD]
[TD]Stuff #[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]1[/TD]
[TD]Person1 stuff 1[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]2[/TD]
[TD]Person1 stuff 2[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]1[/TD]
[TD]Person2 stuff 1[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]2[/TD]
[TD]Person2 stuff 2 [/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]3[/TD]
[TD]Person2 stuff 3 [/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]4[/TD]
[TD]Person2 stuff 4[/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]1[/TD]
[TD]Person3 stuff 1[/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]2[/TD]
[TD]Person3 stuff 2[/TD]
[/TR]
</tbody>[/TABLE]


Is there someway to do this in VBA? Thanks in advance.

 

[Weazel]

just try sorting Column B smallest to largest THAN sort Column A A to Z

 

[jrf1111]

I tried that Weazel but it didn't sort it correctly.

 

[jrf1111]

It gave me something like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person#[/TD]
[TD]Stuff#[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[Weazel]

you could try going to DATA, click on SORT...sort by...Stuff #.....add a level....then by...Person #....both sorted on values...Order....smallest to largest and A To Z

 

[jrf1111]

I tried that. It did the same thing as above. I think I need a VBA code to do this.