I am trying to set up a monitoring file for events but unsure of how
can I do it using Excel.
There are different types of events, but basically they are Rights,
Tender Offers, Warrants, etc These Events consist of
response date or deadlines which owners have to revert by then. Any
one event may have about 20 to 30 owners.

I would like to have a program which monitor the responses by owners
on their decision to take up or lapsed the said event, and at the same
time, list those who have yet to response so that I can send reminders.

Any suggestions or ideas are very much appreciates. I have been trying
to figure this for a couple of weeks but have no idea of how to start
at all.