VLookup or....?
 

So my situation is this, I have a workbook that consists of my
employee's on each tab at the bottom. This is created to keep a record
on them for things they do well, or things that, well, they don't well.

One of the columns (Column C)is labeled "Incidents" and I have created
a drop down list for this column. What I would like to do is this, on
the first page of the workbook going down ColumnA is their names and
across the top of each column a subject. It would look something like
this:

Column A Column B Column C Column D Column E Column
F
Row 1
Row 2 Item1 Item2 Item3 Item 4
Item 5
Row 3
Row 4 emp1
Row 5 emp2
Row 6 emp3
Row 7 emp4
Row 8 emp5

Item's 1-5 are what's in the drop down list in Column C. On the first
sheet, I would like a total of how many times Item1 popped up in Column
C for each employee. And the same for each item for each employee, so I
can see how many times they stayed late to help out, or how many times I
have received a complaint from a Customer.

Thanks for the help


--
respinosa
------------------------------------------------------------------------
respinosa's Profile: http://www.excelforum.com/member.php...o&userid=35231
View this thread: http://www.excelforum.com/showthread...hreadid=550089