Forum Discussion
CPryde
Jun 25, 2019Copper Contributor
Creating a workorder tracking sheet linked to a work order
I need to create a work order tracking sheet which has several columns such as property, address, description of work, date, assigned to, number etc. Each time I enter information into this sheet I ...
Jun 25, 2019
CPryde if you only want to print the work order details from the info entered into the tracking sheet, you can create the layout for the printed paper on a new Excel sheet. In one cell let the user select or enter a work order number from the tracking sheet. Then use lookup formulas to fill in the information on the work order sheet, then print that sheet.
For example, if the tracking sheet is called Work Order List, create a new sheet called Print Work Order. In cell B1 enter a valid work order.
In cell B3, pull the work order description with a Vlookup formula.
Find a sample file attached.