We would like to use Excel 2007 to have a simple spreadsheet that allows us to list all our reoccuring events such as domain name renewals, web hosting renewals, antivirus renewals and contract renewals. We would have 3 colums: Date, Customer Name, Reminder.
We would like to be able to add to this Excel spreadsheet and for it to automatically add a caladar entry into our Outlook 2007 calandar so that we will get a reminder when they are due. We would like to calandar entry to be added 1 week before the due date field in Excel.
This needs to a simple solution that requires minimal effort by end user. We could live with some kind of "Update" button in Excel if thats whats needed.