The problem i have is that I need a 12 month calander that highlights and tells me when a contract is up for a renewal. For example if a customer's contract expires in May, I want it to advise me of this and possibly even highlight it on screen. As well as providing me with a hardcopy
I have attempted to do this using excel with the job names down one side and the months from jantodec along top, but i cant seem to get it to filter the relevant info.Within the cells i've been typing the word "renew" where a renewal is due.
is there any easier,software i can use that will allow this? i have thought about doing it in outlook and using the diary/appointment manager but i dont think u can print off the events or the entire run from jan to december.
Any advise appreciated.thanks so much.
I have attempted to do this using excel with the job names down one side and the months from jantodec along top, but i cant seem to get it to filter the relevant info.Within the cells i've been typing the word "renew" where a renewal is due.
is there any easier,software i can use that will allow this? i have thought about doing it in outlook and using the diary/appointment manager but i dont think u can print off the events or the entire run from jan to december.
Any advise appreciated.thanks so much.