I have new list I am trying to create, in which I get alerted, if a date approaches to renew contracts. Here is what I need:
- Upon opening the file, a popup window will appear and list the names (column A) and Dates (column E) of all those persons, whos contract will expire or who are leaving
- This should happen 4 weeks before the expiry date in column E
- It should also include dates that have past the deadline (eg. if the deadline is 30.7., the item should still appear, until the date is changed into the future)
- It should include those lines, where the status (column D) is EOC and those whos status is OUT. If possible, list them sorted by EOC first and then those with OUT as status
So it should list White and Black first (both EOC) and then Smith (OUT)
I attached my file.
Is this possible? I found codes that trigger the popup box, but they don't have the option of a condition.
Thanks so much for your help!!!!Popup File.xlsx