Hi all,
Hope you are all well.
I have a question regarding the subject above and would really appreciate your help
I have two sheets (Sheet1 and Shifts)
I am making an annual shift spreadsheet that automatically calculates the shift pattern for the year. Once the shifts are calculated in "Sheet 1" for Team 1, Team 2, Team 3, Team 4 and Team 5, I believe I need to use the Match Index function so that the newly calculated shifts for Team 1, Team 2 etc are copied across to range E8:AI20 in Sheet "Shifts", but only when the value in cells C8:C20 in this sheet match Team 1, Team 2 etc as these cells are dynamic. I have attached some screenshots of my sheets to help you understand what I mean.
Sheet 1 snippet
Sheet "Shifts" snippet
Thanks for any help you can provide.
Many thanks,
SwiftM
Hope you are all well.
I have a question regarding the subject above and would really appreciate your help
I have two sheets (Sheet1 and Shifts)
I am making an annual shift spreadsheet that automatically calculates the shift pattern for the year. Once the shifts are calculated in "Sheet 1" for Team 1, Team 2, Team 3, Team 4 and Team 5, I believe I need to use the Match Index function so that the newly calculated shifts for Team 1, Team 2 etc are copied across to range E8:AI20 in Sheet "Shifts", but only when the value in cells C8:C20 in this sheet match Team 1, Team 2 etc as these cells are dynamic. I have attached some screenshots of my sheets to help you understand what I mean.
Sheet 1 snippet
Sheet "Shifts" snippet
Thanks for any help you can provide.
Many thanks,
SwiftM