I have two excel files. one is a staging inventory and the second one is the a delivery file. The inventory files has all assets number, serial numbers and model, etc..
For every order, the equipment is scanned with a gun in to the deliver file. Here is what I am trying to do:
when I scan a computer, I would like excel (the delivery file) to go pull the scanned asset tag with corresponding Serial and Model (on a row) from the inventory staging file. Once it's pulled in to the delivery file, it should move back to the next row for the next one. in the Inventory file, the row corresponding to the data pulled should either move to a new sheet (that I will name "outbound") so the count in inventory file would be accurate.