MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Events Monitoring

  Asked By: Hondo    Date: Aug 31    Category: MS Office    Views: 630

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.



2 Answers Found

Answer #1    Answered By: Dep Tran     Answered On: Aug 31

From the spec you have given, I would strongly recommend using a relational
database such as MS Access, rather than Excel. It would probably be possible
in Access but it will be a pain to create and ten times worse to maintain.

Answer #2    Answered By: Cesara Fernandez     Answered On: Aug 31

Have you considered conditional formatting please?

Didn't find what you were looking for? Find more on Events Monitoring Or get search suggestion and latest updates.