Need macro that will group rows with duplicate data in a particular column together

Here's what I'm working with...
I have an excel spreadsheet with nearly 15,000 rows that I'm trying to sort. Each row has 68 columns, and represents a single piece of equipment that my company has shipped out to various job sites. The rows are sorted according to ship date, in descending order.

Here's where it gets tricky...
Sometimes as many as 30 separate pieces of equipment will be shipped out to a job site, but they're not all shipped on the same day. Because of that, the rows with the same value in the "Job Name" column aren't always grouped together, and instead are scattered throughout the spreadsheet.

Here's what I'm trying to accomplish...
What I need to do is group all equipment rows that belong to the same "Job Name" together. However, I must also keep those jobs sorted according to "Ship Date", with the most recent job at the top of my spreadsheet. Does anyone know how to create a macro that can do that?

Here's an example of what the spreadsheet looks like now:

{Equip Type, Job Name, Ship Date}

CHILLER.....WESTSIDE MALL.....JAN 28
AIR HND.....WESTSIDE MALL.....JAN 27
CHILLER.....ELEM SCHOOL.........JAN 26
AIR HND.....WESTSIDE MALL......JAN 25
I-PAK..........ELEM SCHOOL.........JAN 24
I-PAK..........ELEM SCHOOL.........JAN 23
AIR HND......JOE'S FACTORY.......JAN 22
AIR HND......JOE'S FACTORY.......JAN 21
AIR HND......WESTSIDE MALL..... JAN 20

Here's how I need for it to look:

CHILLER.....WESTSIDE MALL.....JAN 28
AIR HND.....WESTSIDE MALL.....JAN 27
AIR HND.....WESTSIDE MALL.....JAN 25
AIR HND.....WESTSIDE MALL.....JAN 20

CHILLER.....ELEM SCHOOL........JAN 26
I-PAK.........ELEM SCHOOL........JAN 24
I-PAK.........ELEM SCHOOL........JAN 23

AIR HND.....JOE'S FACTORY......JAN 22
AIR HND.....JOE'S FACTORY......JAN 21

Any suggestions? Thanks!

Hi and welcome to the forum

You dont need a macro for this, you can use excel's built-in sort function.

Highlight the data, select Data Tab, select SORT
1st sort would be Job Name
2nd sort would be date

Excel 2007 => Data => sort

Select all data

sort on column B (job name)

second condition sort on column C (date) from newest to oldest

third condition sort on column A (name)