I have an Inventory tracker and Work Order generator that utilizes two forms and one sheet. The "Work Order" tab shows the most recent work order entered and is populated with form responses from the "Work Order Responses" tab.
I would like to add another tab that compiles all fields found in the Work Order tab, including the calculated field for "Materials Total" in F31, every time a new work order is generated. I just want to have all the work order history under one new tab, organized by invoice number.
(link to file removed by author)
Thanks in advance for any help you can give me with this!