Hello,
I am working towards getting information from other sheets in a workbook all to one sheet for mass emailing Staffing for the week.
Sheet 1 : Has the names of People that gets populated with the roles for the day. The labels are name vs date
Name Mon Tues Wed Thurs
Kristen A B C D
Brett B D A
Patty C A B
Ken D D A B
Sheet 2: Shows the Shift name vs Time of shift start
Role Mon Tues Wed Thurs
A 5:00 6:00 4:00 3:00
B 2:00 4:00 3:00 8:00
C 11:00 14:00 18:00 21:00
D 12:00 13:00 19:00 20:00
Sheet 3: I want to Combine all of the information together into one sheet for emailing. I have used an Index/Match Function to show the roles each person has on a certain day. In the next Column I use another index/match function to show the start time. When I try and fill the two column across the row it skips days of the week
What I want
Mon Mon Tues Tues Wed Wed Thurs Thurs
Kristen A 5:00 B 4:00 C 18:00 D 20:00
Brett
Patty
Ken
What I see when I try and drag the two columns across
Mon Mon Tues Tues Wed Wed Thurs Thurs
Kristen A 5:00 C 18:00
Since the formula is being dragged across rows it is skipping every other Column in sheet 1
Is there a way to fix this problem or make the auto fill not skip rows?
Bookmarks