Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating an column of values from an existing array
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating an column of values from an existing array
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. "PA" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT clue needed | Excel Discussion (Misc queries) | |||
How do I search an array for values in a column greater than zero | Excel Worksheet Functions | |||
How to match values in one column to values in another? | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |