Equipment inventory log

Nikki W

I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigned to someone, and another to archive any movement. I have a form that they fill out when assigning the equipment out which places the information on the equipment assigned spreadsheet. Once the equipment is returned they fill out another form and that information is automated to be copied to the archive spreadsheet and moved to the inventory spreadsheet. I am having trouble automating the inventory spreadsheet to remove the equipment line when it is in use. I hope this makes sense. Thanks in advance for any and all help on making this happen before my go live date on Monday.