Stephanie Sobeck
New Member
Hoping someone can help me. I’m trying to build a sign up for teaching different classes where each instructor would fill in the class to teach (B2:B4) under the appropriate date and it would auto populate to the corresponding sheet as a cumulative list of who signed up. For example, Instructor 1 signs up for CCR on 1/1/17. How could I get “Instructor 1” to appear on the CCR sheet in B3? When the next instructor signs up for the same, I need it to populate B4 instead of overwriting B3. I would need this to occur for each class sheet (MS Res Day 4, CCR, Competencies) if found in any of the date columns and populate to the appropriate date column in the corresponding worksheet.