Glad you got it working. Microsoft should get most of the credit here.

The criteria range can have multiple rows and deliver some strange combinations of data.
You just have to be able to understand the rules (that's what it is all about, isn't it). <grin

Start at the Debra Dalgleish website under the subject of...
"Setting up the Advanced FilterCriteria Range" at http://www.contextures.com/xladvfilter01_2003.html
Also see "Examples of complex criteria" at...
http://office.microsoft.com/en-us/ex...in=EC001022984

In addition, the Excel (not vba) Database functions use the same type of criteria rules.
These are a much ignored set of functions that can be extremely valuable.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Bingo Card Variety .xls workbook - in the free folder)




"John Smith"
wrote in message
...
Jim,
That worked great - you're a genius. But how do I get it to search
multiple fields? Lets say a supervisor (Jones, Dale E.) has an
emplyee (Thomas, Mark) and he wants to see how many jobs he has
charged to a specific work area (4544). The employee has transferred
to a different department during the year, but it's only the time
charged while he has been working for his current supervisor that the
auditors want to see.