I recently downloaded an Excel calendar template that shows one moth or one week at a time, and is linked to a second tab with assignments and dates the assignments are due. What I would like to do is:
1. Rather than have the words "Assignment Due!" appear on the specific date, I would rather have the actual event post. These events are tasks, and the calendar format is preferred for viewing.
2. There is also the likelihood that multiple tasks will be due on any given day. Is there a way to display all of the tasks on their due date?
I have tried using variations of the code included with the template and VLOOKUP without success. Any ideas?
Thanks,
Dana
Excel 2010 user
Bookmarks