+ Reply to Thread
Results 1 to 5 of 5

Automatically Sort Due Dates as They Change

  1. #1
    Registered User
    Join Date
    08-15-2014
    Location
    CA
    MS-Off Ver
    2010
    Posts
    2

    Automatically Sort Due Dates as They Change

    I'm attempting to get a column of due dates to update automatically every time a date changes. The due dates are in B3:B15. There is a header in B3. The day after the actual due date, it is automatically changed to the same day on the next month (showing the next due date). I need the spread sheet to automatically sort the due dates from the closest due at the top, to the furthest due date from today at the bottom. Running it manually, or sorting it manually every time won't work. This is for an elderly couple who are having problems keeping track of everything each month. I just need something that will show them the upcoming bills and how soon they are due when they open the workbook. Anything other than opening the workbook is going to be too complicated. I'm new to macros. I've tried to modify some I've found in other threads, but no luck (lots of error messages). I don't understand it enough yet to figure out what I need to change. I've attached a sample sheet that shows the part of the workbook I'm having trouble with. Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by LilyRB; 08-15-2014 at 08:08 PM.

  2. #2
    Forum Contributor
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    103

    Re: Automatically Sort Due Dates as They Change

    See if this works for you. The macro will run every time the workbook opens.
    Attached Files Attached Files

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Automatically Sort Due Dates as They Change

    Hi Lily,

    Try this: Lily.xlsm
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  4. #4
    Registered User
    Join Date
    08-15-2014
    Location
    CA
    MS-Off Ver
    2010
    Posts
    2

    Re: Automatically Sort Due Dates as They Change

    xladept, thank you so much for helping! That did the trick. Works perfectly as the date in A1 changes. Thanks so much for the quick reply. I really appreciate it.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Automatically Sort Due Dates as They Change

    You're welcome and thanks for the rep!

+ 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. Dates Change on Sort due to reference to cell above.
    By Goodbuddy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2013, 04:06 AM
  2. I want the dates to change automatically so I can print out a year's worth.
    By MrHappyGoLucky12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2013, 09:02 PM
  3. Replies: 4
    Last Post: 11-28-2012, 11:44 AM
  4. [SOLVED] Numbers change to dates automatically
    By Aa in forum Excel General
    Replies: 3
    Last Post: 11-01-2005, 10:05 AM
  5. [SOLVED] Sorting dates:How do I sort a column filled with dates by Month, Day, then Year?
    By Heather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 10:05 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