Can I create a form to move lineitems off of one sheet and onto another?
I have an sheet that is populated by an intake form (call this form1). This sheet represents received inventory. I would like to create another form (call this form 2) that will de-populate the first sheet once the material is deployed and move the lineitems to another sheet to represent the status change. The idea is that employees will beable to fill out form 2 in order to request the deployment of a particular line item. Once form 2 is submitted the line item would be populated on another sheet. We have already achived the movement of lineitems from one sheet to another by using logic in a "deployed" feild. We would now like to implement form 2 inorder to create a digital record of the deployment request that will corolate to the movement of the lineitem from one sheet to another. Is this possible?