Creating an column of values from an existing array

[PA]

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

 

[hmm]

The best way to do it is by using an auto filter. Put the selection point in
the Repair Tech column (a label "Repair Tech" should appear above the data
with no blank rows in between). From the menu: Data, Filter, AutoFilter.
You will get a pull-down menu that allows you to select a Tech to view all
his rows of work orders.

If you want it to appear in another worksheet, first copy the original table
(only the work orders, NOT the whole sheet!), go to a new workbook and from
menu: Edit, Paste Special, Paste Link. You can delete or hide unneeded
columns if you wish, then perform the auto-filtering described above.