View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max2073 Max2073 is offline
external usenet poster
 
Posts: 40
Default Deleting Rows with a macro based on a date value

I have a spreadsheet with 8000 rows. In column E I have dates (estimated
completion dates) - I would like to delete rows that are are not due within
the next seven days and/or which are not overdue.

eg. Today - 7 September 2009 - I would like to leave all rows that are due
upto the 14 September 2009 (left in the spreadsheet would be any outstanding
records that are overdue eg. 10 August 2009.