I created a worksheet to track my service tickets. One column has a checkbox indicating that the work is to be accomplished by a subcontractor. I want to create a new worksheet (not report), that tracks the status of subcontractor work.
My thought is, when the checkbox on the primary worksheet is checked, part of that work order information is copied to the subcontractor sheet where there are status checkboxes. Once the "work completed" box is checked, it is reflected back to the primary worksheet as completed. (via a checkbox/date combo).
Can I do this?
