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?

Yes it can be done. Thre aren't enough details (range of cells for
summary sheet, and sheet names where data appears). You only included
one range of data with no sheet name.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160150

Microsoft Office Help