Dilemma: I would like to auto-populate the information from sheet 1 to other sheets depending on the information provided.
Example: Sheet 1 is the Main Matrix it has 6 columns.
Col 1: Name of a person
Cols 2-6: Room Assignments
---- Col 2: Pantry; Col 3: Front Desk; Col 4: Board Room; Col 5: Security; Col 6: VIP Room
If I mark "x" on Col 3 for person 1, the person's name should be automatically copied to the sheet "Front Desk". If I mark "x" on Col 2 and Col 4 for person 2, the person's name should be automatically copied to the sheet "Pantry" and "Board Room".
I am not that familiar with macros. Hope someone can help me. Attached is the sample look.
Example: Sheet 1 is the Main Matrix it has 6 columns.
Col 1: Name of a person
Cols 2-6: Room Assignments
---- Col 2: Pantry; Col 3: Front Desk; Col 4: Board Room; Col 5: Security; Col 6: VIP Room
If I mark "x" on Col 3 for person 1, the person's name should be automatically copied to the sheet "Front Desk". If I mark "x" on Col 2 and Col 4 for person 2, the person's name should be automatically copied to the sheet "Pantry" and "Board Room".
I am not that familiar with macros. Hope someone can help me. Attached is the sample look.