+ Reply to Thread
Results 1 to 5 of 5

help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    8

    help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

    I'm not too sure how to explain this.

    I have this spread sheet of contracts and I need to keep track of their expiration date which is from today and 90 days out and update it every day to make sure that I am not missing anything


    Is there a way I can have Sheet 2 populate with all of the contracts that are expired or are going to expire? I also need each line to show so I know what company needs the renewal

    I've attached an example sheetExample Sheet.xlsx
    Last edited by JennK; 04-02-2012 at 12:33 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

    Take a look at your modified workbook attached. I added a "Days Until Expiration" column that should help. It does update each day.
    Attached Files Attached Files

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,745

    Re: help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

    Will a filter on sheet 1 work for you? With a filter, you can display only those entries that meet whatever criteria you set. So, if for instance, you want to only display those records up to 90 days from today, you can either set that in your filter, or have a date in your sheet that the filter refers to.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    03-27-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

    Dennis,
    That is great!!!!! Thank you so much!!! But is there a way besides cutting and pasting that I can make the expired ones or the ones with 90 days or less to be transferred over to Sheet 2?

  5. #5
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out

    You can always sort the table by "Days Until Expiration". Then it just copy/paste work.

    or

    You can do what FDibbins suggested. Use the Autofilter. Then it just copy/paste work.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1