Use Excel Date to create Outlook Appointment
First post here, so I'll try to be thorough in my explanation. I have an Excel spreadsheet where a person enters a book title and a due date. I need to take that due date & title from XL to a reminder in Outlook. I've found lots of VB macros to do that, my problem is that the user will be entering dates all the time and I want her to be able to execute the macro for each entry that she makes. In other words, I need the macro to execute based on the current cell position. I've written macros before, but it seems like everything I know is not working in this particular instance!
In A2, I might have the name of a book and in B2 the date it is to be returned. I want her to be able to execute a macro with her cell pointer sitting in B2 that will pick up the name of the book and the due date and put a reminder on her Outlook calendar. Tomorrow if someone else borrows a book and she enters that information into A3 and B3, again I want her to be able to execute that macro from B3 to pick up those to entries and make a reminder in Outlook.
Any help anyone can provide is much appreciated!!