Notice to purge data

wgansert Posts 1 Registration date Thursday July 21, 2016 Status Member Last seen July 21, 2016 - Jul 21, 2016 at 01:36 PM
 Blocked Profile - Jul 21, 2016 at 04:17 PM
Hello -

Any information or help will be appreciated.

Is there a formula that can alert data entry personnel when a particular entry, needs to be purged after a given number of years (3)?

1 reply

Blocked Profile
Jul 21, 2016 at 04:17 PM
You can have it check a value upon opening with:

Private Sub Workbook_Open() something here every time the book opens, extending the opening processing as the file grows......
End Sub

You could do that to start. Now all you would need to do is find a date value in a range. Let us know which part you are stuck with, as we cannot provide a turn key solution (well I won't but others will, if you stick around long enough!)