I have a spreadsheet to show scheduled dates for account reviews and dates invoices were requested from customers. What I'm trying to do, with absolutely no joy so far , is use a macro that recognises when a date is inputed into a "bills requested" cell to then automatically enter an event into my outlook 2003 calendar to prompt me to chase the customer if they haven't returned their bills within a specific time. So far I've found lots of helpful info through this forum to send emails, but I'm coming up against a bit of a brick wall where the calendar is concerned.
Any help would be greatly appreciated.