I have a list of peoples 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:D22.
This works great for the moment, as Ive 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 theyre 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 dont 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 persons name would appear on the master sheet.
Can this be done?