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

[JennK]

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

[Dennis7849]

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

[FDibbins]

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.

[JennK]

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?

[Dennis7849]

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.