Hi!
I want to delete rows that has a date in column H that is 7 days older than today.
Preferably I'd like the macro to run when someone open the worksheet (possible with Private Sub Workbook_Open()?).
So that it automaticly wipe away rows that's not relevant any more.
Is this possible? Can anyone help me with this?
I'd greatly appreciate it.
I want to delete rows that has a date in column H that is 7 days older than today.
Preferably I'd like the macro to run when someone open the worksheet (possible with Private Sub Workbook_Open()?).
So that it automaticly wipe away rows that's not relevant any more.
Is this possible? Can anyone help me with this?
I'd greatly appreciate it.