R
respinosa
So my situation is this, I have a workbook that consists of m
employee's on each tab at the bottom. This is created to keep a recor
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 create
a drop down list for this column. What I would like to do is this, o
the first page of the workbook going down ColumnA is their names an
across the top of each column a subject. It would look something lik
this:
Column A Column B Column C Column D Column E Colum
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 firs
sheet, I would like a total of how many times Item1 popped up in Colum
C for each employee. And the same for each item for each employee, so
can see how many times they stayed late to help out, or how many times
have received a complaint from a Customer.
Thanks for the hel
employee's on each tab at the bottom. This is created to keep a recor
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 create
a drop down list for this column. What I would like to do is this, o
the first page of the workbook going down ColumnA is their names an
across the top of each column a subject. It would look something lik
this:
Column A Column B Column C Column D Column E Colum
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 firs
sheet, I would like a total of how many times Item1 popped up in Colum
C for each employee. And the same for each item for each employee, so
can see how many times they stayed late to help out, or how many times
have received a complaint from a Customer.
Thanks for the hel