Notice to purge data

[Closed]
Report
Posts
1
Registration date
Thursday July 21, 2016
Status
Member
Last seen
July 21, 2016
-
 Blocked Profile -
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


You can have it check a value upon opening with:

Private Sub Workbook_Open()
...do 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!)

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month