M
Manxy
I have a list of people’s names going from top to bottom C9:C22.
The next heading for column D is to do with time (as also E, F, G, H, I and
J) and if the person was working that time slot, then a figure 1 would be
used in cells D9
22.
This works great for the moment, as I’ve placed a COUNTA for that area which
indicates the number of people working at that specific time slot. (Obviously
you have to watch out for the dot or space keystroke)
I have another 3 other programmes doing exactly the same thing with
different people. Again, this is not a problem as they’re all separate.
My problem arises when I want to create a master sheet that incorporates all
4 programmes, but instead of indicating a 1 and a total, I want it to give me
the names of people working a specific time slot.
I don’t understand macro and have some small successes using excel 2007 and
the way I was looking at it was; If a figure one was placed in cell D9 (for
instance), then the person’s name would appear on the master sheet.
Can this be done?
The next heading for column D is to do with time (as also E, F, G, H, I and
J) and if the person was working that time slot, then a figure 1 would be
used in cells D9
22.This works great for the moment, as I’ve placed a COUNTA for that area which
indicates the number of people working at that specific time slot. (Obviously
you have to watch out for the dot or space keystroke)
I have another 3 other programmes doing exactly the same thing with
different people. Again, this is not a problem as they’re all separate.
My problem arises when I want to create a master sheet that incorporates all
4 programmes, but instead of indicating a 1 and a total, I want it to give me
the names of people working a specific time slot.
I don’t understand macro and have some small successes using excel 2007 and
the way I was looking at it was; If a figure one was placed in cell D9 (for
instance), then the person’s name would appear on the master sheet.
Can this be done?