Sort based on column values then repeat

[jrf1111]

Hi all, I have a worksheet that looks something like this:

Person#	Stuff #	Data
Person1	1	Person1 stuff 1
Person1	2	Person1 stuff 2
Person2	2	Person2 stuff 2
Person2	4	Person2 stuff 4
Person2	3	Person2 stuff 3
Person2	1	Person2 stuff 1
Person3	2	Person3 stuff 2
Person3	1	Person3 stuff 1

<tbody>
</tbody>

For some reason Excel won't sort first by Col A (Person #) then by Col B (Stuff #) so it will look like this:

Person#	Stuff #	Data
Person1	1	Person1 stuff 1
Person1	2	Person1 stuff 2
Person2	1	Person2 stuff 1
Person2	2	Person2 stuff 2
Person2	3	Person2 stuff 3
Person2	4	Person2 stuff 4
Person3	1	Person3 stuff 1
Person3	2	Person3 stuff 2

<tbody>
</tbody>

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

Person#	Stuff#
Person1	1
Person2	1
Person3	1
Person1	2
Person2	2
Person3	2
Person2	3
Person2	3

<tbody>
</tbody>

 

[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.