move a specific row of data to a specific sheet based upon a condition

Copper Contributor

Greetings Microsoft community

  I have a separate question for everyone, and hope that someone would be able to assist me.  For my inventory sheets, which are spread amongst different sales representatives in different states, once a sale is completed, and the item is marked as customer committed (the tricky part is that the inventory is on several different worksheets in the same book), I want the entire row to be removed from the Inventory record and placed onto the sheet inventory sold workbook. 

0 Replies