View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JAbels001 JAbels001 is offline
external usenet poster
 
Posts: 28
Default VBA code needed for auto deletion upon opening

I need help writing a VBA code for 2007 Excel. I have a document that
multiple people have access to. Within this document there are dates and data
next to those dates. I need all dates deleted upon being opened if it's
greater than 6mos from the date that it is opened. The dates are in columns
E, H and K and the data for each date is directly to the right (F, I and L).
The information goes all the way down from row 5 to row 450. I hope this
makes sense.