I'm attempting to build a report which takes data that includes dates, names and events with start/end times and inserts a comment onto another sheet which contains a schedule which corresponds with the dates/names.
I have code for inserting comments but where I'm stuck is figuring out the best way to have Excel store all event data (events + start/end times) per day, per name and have the names and dates matched on the calendar sheet so the comments are inserted in the correct cell.
I've been reading about and trying to use named ranges and variable arrays but am looking for any additional help you fine folks may be able to provide.
The end result of what I'm trying to achieve is to have the calendar look like this: http://i.imgur.com/55z4Ppi.png
Thanks!
Bookmarks