We have created a workbook to track Work Orders for repairs on equipment to
our customers in a four state region. One worksheet is used to enter the
workorders, row by row, starting in column A out to AA. Column A has work
order number (very simple €“ 1,2,3,etc). Column B is Lot #.

The next several columns are Dates; Entered, Issued, Inspected, Due, Days
Overdue, Date Completed, Completed (Yes or No is selected from a Validation
list), and Repair Tech. The remaining columns relate to Names, addresses,
descriptions, etc, and are not relevant to my question.

I have created a Form on another worksheet so that when a the workorder
number entered in a cell, the information in the above referenced columns is
looked up and pertinent cells are populated using VLOOKUP. This form is then
printed.

What I would like to be able to do, on another worksheet is specify a Repair
Tech in a cell and create a list all incomplete work orders for that tech,
also pulling up the due date. Either the completed date field (being blank)
or the completed field (specified as No) would need to be examined, the list
created.

If useful in offering some guidance, Work Order Numbers are inColumn A, Date
Completed is J, Completed (Yes or No) is in K, and Repair Tech is in L.
Thank you for any help on the important issue.
Paul