Hi,

I think you are looking for something like this - Question 7 on
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Barry" wrote in message
...
Hello All

Please excuse me for an unclear subject. I will try to decribe my problem
as
clear as possible.

I have a spreadsheet which helps me measure productivity of my staff. I
have
three departments (BULK, FLAT PICK and HANG PICK). Each spreadsheet
contains
following::
NAME | TOTAL PICK | TOTAL TIME | AVG UPH | TARGET |
John Doe 10,000 100 100
120

I have a list of over 200 employees with these figures. I am trying to
find
a way to force excel to identify people who are not reaching the target
(which changes every week depending on the type of product comming through
the door) group them all in one table on a separate tab which I can hand
out
to Team Leaders.
Please remember that I would like that info to be shown on a separate tab.

I know a bit about excel but this is simply out of my league.