Results 1 to 5 of 5

Automatically Sort Due Dates as They Change

Threaded View

LilyRB Automatically Sort Due Dates... 08-15-2014, 05:42 PM
morbdetro Re: Automatically Sort Due... 08-15-2014, 06:56 PM
xladept Re: Automatically Sort Due... 08-15-2014, 07:04 PM
LilyRB Re: Automatically Sort Due... 08-15-2014, 07:26 PM
xladept Re: Automatically Sort Due... 08-15-2014, 07:45 PM
  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.

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. Numbers change to dates automatically
    By Aa in forum Excel General
    Replies: 3
    Last Post: 11-01-2005, 10:05 AM
  5. 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