Results 1 to 4 of 4

Sorting Data by Date

Threaded View

  1. #1
    Registered User
    Join Date
    11-24-2008
    Location
    York
    Posts
    26

    Sorting Data by Date

    I have a Column J with Dates formated in the dd/mm/yyyy format how do I used the Selection.Sort key:= xx order:= to sort the rows that have a date in the selected columns. Where J_End in the code below is the Column I need to refer to its sorting to a point but im not sure whats wrong with it.

    All I really need it to do is group all the ones with a date (completed) and without a date (not completed) thus why im sorting it and the other stuff prioritize it.

    Selection.Sort Key1:=Range("C_End"), Order1:=xlAscending, Key2:=Range("J_End") _
            , Order2:=xlAscending, Key3:=Range("B8"), Order3:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
            False, Orientation:=xlTopToBottom
    Last edited by Dragonruler12; 12-02-2008 at 10:15 AM.

Thread Information

Users Browsing this Thread

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

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