View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Clearing data past its sell by date!

Presumably you have a date column. You could apply a filter to this -
Custom, Less than then enter today's date. This will display the old
records. Highlight the visible rows and Edit | Delete Rows, then choose
All from the filter pull-down.

Hope this helps.

Pete