Results 1 to 5 of 5

sort data based on date and time priority

Threaded View

  1. 02-18-2010, 04:50 PM #2
    justinvalle
    justinvalle is offline
    Registered User
    Join Date
    07-29-2009
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: get the priority data base on date and time comparison

    By "first slot" I'm guessing you want it sorted so that it's at the top.

    I'm not sure how you intended to cause the event so I added a button that triggers the below code, enjoy.

    Range("A8:C15").sort Key1:=Workbooks("test.xls").Worksheets("Sheet1").Columns("B"), Order1:=xlAscending
    Attached Files Attached Files
    Last edited by shg; 02-18-2010 at 07:12 PM. Reason: deleted spurious quote
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1