Creating to do lists
Hello.
I need some help with creating a todo list. I work in recruitment,
and we have certain things to do after certain periods of time. For
example, I have to contact the hiring manager 2 days after a vacancy
closes, which is 14 days after it opens. I have created a spreadsheet
with all the different activities and their dependancies, and I can
put in the opening date and get a list of other dates when I need to
do something.
The problem is, I have 30+ jobs on the go at one time. What I want to
do is have excel scan all the data, then present me with a date
ordered to do list.. so I can see all the activities I should be doing
today.
Is this possible?
thanks for your help.
Wendii
|