D
Darrell
I am trying to create a worksheet that will show a list
of tasks that need to be completed down the columns(1-50)
and a list of staff across the top(A-H) and then have a
tick or cross against each cell to signify that the person
has completed the task(or not).
My problem is that I cannot find a way to tell excel that
I want to see the ticks and crosses for either
a): a specific person
b): a group of people (department name like Accounts Dept)
c): all the names
I have looked a pivot tables and vlookup but am going
around in circles.
Can anybody help me on this?
Many Thanks
Darrell
WSM/UK
of tasks that need to be completed down the columns(1-50)
and a list of staff across the top(A-H) and then have a
tick or cross against each cell to signify that the person
has completed the task(or not).
My problem is that I cannot find a way to tell excel that
I want to see the ticks and crosses for either
a): a specific person
b): a group of people (department name like Accounts Dept)
c): all the names
I have looked a pivot tables and vlookup but am going
around in circles.
Can anybody help me on this?
Many Thanks
Darrell
WSM/UK