Grouping Rows of Data and Sorting Help Needed?

[shaqattack1992-newsgroups]

I have been given a spreadsheet that is 12 columns wide and is up to 7
rows deep.

It looks something like this:

Column 1Column 2-----Column 3........Column 4.....Column 11---Column 12
------------------------------------------------------------------------------------------------------
Part1------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX---Item
1
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX----Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX----Item
5
(Blank Space)
Part2------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX----Item
7
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
5
(Blank Space)
Part3------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
1
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5
(Blank Space)
Part4------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
12
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
13
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
15
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
15
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
17
(Blank Space)
Part5------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
7
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5

Each part # consists of several rows. What my boss wants to do is sort
these so that all part groups that have the same column 12 will be
together and it the same column 12 order. For example this should be
the result:

Column 1Column 2-----Column 3........Column 4.....Column 11-----Column
12
----------------------------------------------------------------------------------------------------------
Part1------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
1
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5
(Optional Blank Space)
Part3------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
1
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5
(Optional Blank Space)
Part2------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
7
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5
(Optional Blank Space)
Part5------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
7
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
3
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
5
(Optional Blank Space)
Part4------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX-----Item
12
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
13
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
15
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
15
-------------XXXXXX--------XXXXXXXX---------XXXXXXXX....XXXXXXXXX------Item
17

Is there any way of doing this? This sheet has 25,000 rows of data,
and we need a way to do this. I'm not really an expert in Macros or
VBA. Any help would be greatly appreciated. I'm kind of in a bind
with work.

-Chad