+ Reply to Thread
Results 1 to 1 of 1

Vba sort list

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2003=7
    Posts
    25

    Vba sort list

    Hi All,

    I have a list that looks like:
    Capture.PNG

    The list starts from column O and can run across to column Z, and the numbers in the list go up to 89.
    When I sort the cells in Excel by O, then P, Q...etc then I end up with a list like I have shown above.

    This list is to show dependencies of jobs. Therefore, on the row where the dependencies go '1,2,3,4,5,6,7,8,9,10' I'd like to see it sorted so that it comes under the dependency '10'.....because how can I run a job just after job '1', when it dependends on '1,2,3,4,5,6,7,8,9,10' being complete aswell!

    Below is the code I have attempted and attached is an example workbook to work with. I have a few MsgBox's just for de-bugging to try and help me figure out the problem..as you can see that didn't go so well! Also, (anyone who helps me - thank you in advance!!!!) save the workbook first...my code eats rows/makes them do a disappearing act...
    Please Login or Register  to view this content.
    Thanks in advance, I've been struggling a long time on this!
    Attached Files Attached Files

+ 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. [SOLVED] difficult:sort list of players by team from player list on separate sheet
    By Biff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  2. [SOLVED] sort list of players by team from player list on separate sheet
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. sort list of players by team from player list on separate sheet
    By Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. Excel sort by Fill Color by custom list sort
    By Dash4Cash in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 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