Hello all,
I have a bit of a challenge here if anyone can help. I'm not entirely sure if it's even possible but I'm sure I've seen someone do something similar on a YouTube video but I may be mistaken.
I want a formula (or formulas) in the range B8:O19, which will pull back information from specific worksheets based on the selection in cell B4. This formula would have to bring back corresponding 'Options' chosen for each 'Employee' depending on whether there is a tick in that field, this can all be returned in one cell if possible. I have done an example of how I would want it to look. If it is not possible the way I have drawn, I would be happy to entertain alternatives. I'm just keen not to rewrite the entire row of Options, and rather have the chosen ones show up individually.
Any help with this would be a massive help to me.
Note this is not the actual data and rather a sample of the thing I am looking for.
Many Thanks
I have a bit of a challenge here if anyone can help. I'm not entirely sure if it's even possible but I'm sure I've seen someone do something similar on a YouTube video but I may be mistaken.
I want a formula (or formulas) in the range B8:O19, which will pull back information from specific worksheets based on the selection in cell B4. This formula would have to bring back corresponding 'Options' chosen for each 'Employee' depending on whether there is a tick in that field, this can all be returned in one cell if possible. I have done an example of how I would want it to look. If it is not possible the way I have drawn, I would be happy to entertain alternatives. I'm just keen not to rewrite the entire row of Options, and rather have the chosen ones show up individually.
Any help with this would be a massive help to me.
Note this is not the actual data and rather a sample of the thing I am looking for.
Many Thanks