Have Excel automatically send an appointment to Outlook

[paulw793]

I did a bit of googling before I found this forum, but still have yet to find an answer.

I've got a spreadsheet (huge) that has a list of dates in column F.



Is it possible to have Excel automatically put a date in Outlook's Calender 30 days from the date in column F(only > 01/01/11) with the subject of Column B, but only the rows with an "X" in column G?

Here is the link to the SS so you can get a better understanding:
https://docs.google.com/spreadsheet/...lzOUE&hl=en_US