Hi Everyone -
I've seen a couple of posts regarding similar needs, but not quite what I am looking for (though I think I am really shooting for the stars given my experience level). I run a study that runs groups of people in through about 26 separate appointments. While the first group may be on the 20th visit, I may have other groups on the 3rd or 16th visit, for example. As you can imagine, as I begin having more and more groups doing different visits, eventually they will overlap. I am trying to salvage my sanity by creating an Excel file that will populate a calendar (preferably color-coded by "cohort" or group) so that I can quickly see that I have "Cohort 1" doing "Event C" while Cohort 3 is doing Event A while also Cohort 2 is doing Event B. I have attached my drafted table for a reference of what I am looking for.
Thanks in advance for any help!
-mdp
Bookmarks