Results 1 to 7 of 7

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

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    4

    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!
    Last edited by MineThatBird; 09-08-2013 at 01:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to Group Rows Along a Range Based on Values in a Column
    By JHCali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-06-2013, 10:20 AM
  2. [SOLVED] Need a Macro that will duplicate rows a number of times based on a column value
    By Lassitude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2013, 12:04 PM
  3. Copy column data by group/category, where the number of rows change
    By davidmurphy25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2012, 10:25 PM
  4. Replies: 5
    Last Post: 06-11-2009, 08:57 AM
  5. Replies: 7
    Last Post: 06-19-2006, 01:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1