Lets say I have a date in column I. Is there a way to automatically delete the row after 3 months when the worksheet is opened or changed?
So if the date in column I is 1/1/2008 then on 4/1/2008 the row with that date would automatically delete. I would need this to go through every row which could be a few hundred rows long.
Anybody have any ideas on how to do this?
Thanks