I have a major event coming up for my organization where we are getting a couple hundred people together. Each person has an individual itinerary and so I would like to make everyone a post card that outlines their day and their meetings.
Here is a sample of the Data (Contact Info Changed to fake info)
District Meeting With Room # Office Phone Meeting Time Attendees
1 Rep J 10 867*5309 1:00 Jim, Cathy, Bill
2 Sen B 12 18775211 2:00 Jim, Jannet
3 Sen A 9 123456789 12:00 Cathy, Jannet
What I want to do is find a way to make Jim, Jannet, Cathy, and Bill each their own postcard with Meeting times and locations. Since the attendees for each meeting are all listed in the same cell I am not sure how best to do this. Typing these would take a lot of time and this cannot be done until the last minute as data will change up until the morning of the event.
My excel ability is that I can do almost anything with it as long as I have a detailed set of instructions.
Bookmarks