Using VBA with Lookup to create participant schedules.

I am trying to create individual participant schedules. I have created a sample excel file that shows what I want to do however I cannot figure out how to add my attachment. My actual file has 150 registrations, and many more session times.

The registration data for each participant is shown in a separate row. Participants have indicated their top choice with a 1. Each group of 5 columns (ie. T1-H1, T2-H1, T3-H1, T4-H1, T5-H1) is one time slot and the participant will have a 1 in only one of the columns in this group. They have also indicated their second choice. At this point in time, we only have a couple of sessions that are overfilled that will require participants to take their second choice. In these situations, we can manually adjust their selections.

The schedule tab shows the sample participant schedule. I have used the Lookup function to pull the data to give an example of what I want to do. It looks up their first choice for each time slot, and based on that choice, it fills in the room number where the session is delivered, as well as the name of the session. The session times do not change so could be typed into a template manually, or I could put them on a separate tab in the worksheet to pull from.

I need to create a separate schedule for each participant, and do not want to have to do this manually 150 times.

Thank you for your suggestions.

Thank you. Yes, I could reorganize my data to look like that using the Lookup function. For the printable participant schedule however, I do want to keep the vertical layout.

I am very new to VBA so I'm not sure how to use the three strings that you gave me.