+ Reply to Thread
Results 1 to 5 of 5

Macro for sort rows after value in certain column

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,050

    Macro for sort rows after value in certain column

    HI I would like to have some help for below macro i need.

    I need to sort the rows after customer numbers in column C4 and down.
    I can sort if off course, but in this case i need it to be sorted so the ones with most same numbers come in the top and so on down.

    Example.. if i have 5 with the same customer number they need to be in top if this is the highest amount of same numbers.
    And under example the one with 4 of the same.

    So on all the way down. I have put the sheet in here to try one. Sheet 2 have have the data

    Please have a look Need a macro because its part of a bigger project.

    Thanks in advance

    Sincerely

    Abjac
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,356

    Re: Macro for sort rows after value in certain column

    Hi Abjac,
    try it
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,050

    Re: Macro for sort rows after value in certain column

    HI Nilan.Thanks for your answer. I tried it but it seems not to work. There was 3 numbers which was collected but i checked other and they have dublettes.
    Please have a look maybe in my test sheet. Just checked more. From exactly row 100 it stop. Dont know it its important.

    Thanks in advance

    Sincerely

    Abjac

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,356

    Re: Macro for sort rows after value in certain column

    Oops, my mistake
    try again
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,050

    Re: Macro for sort rows after value in certain column

    Hi Nilem.

    This one did the trick now. Great really thanks allot .

    A big help for what i am doing now.

    Sincerely

    Abjac

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-26-2013, 09:27 AM
  2. [SOLVED] Macro to sort variable rows of data by a column in multiple sections
    By mannuhs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2013, 03:22 PM
  3. Macro to sort rows by date which appears in Column (B)
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2013, 10:27 AM
  4. [SOLVED] Macro to sort data by column B within the Location & Total rows?.
    By ludsonline in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2013, 06:04 AM
  5. How to sort on column C, but not include any rows with an x in column L
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2010, 10:23 PM

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