Hi all,
I have an Excel 2007 spreadsheet which I use, in addition to storing child screening data, to store dates those screenings are due - that I use (rather ineffeciently) as a tickler.
What I would REALLY like to do is have some kind of a macro (I suppose it would be a macro; I'm not too savvy) to cause a calendar event (preferably an all day event) to be created in my Outlook (2007), when the date something is due (say, in Cell 1) matches the current date (which is in another cell, say cell 2). AND, I'd like the identifying information (say, in cell 3) to become the text associated with the calendar entry.
I've attached a small sample Excel spreadsheet (Sorry it's a JPEG visual), with the three relevant cells (referenced above) highlighted as Green (cell 1), Blue (cell 2), and yellow (cell 3).
Anybody know how to do this? Thanks to all of you wizards who share your wisdom.
HS_ECSE
Bookmarks