Hello, I have something I am trying to solve and have been searching all over. 

I have a sheet made to help keep track of stuff taken from the warehouse. We have a scanner that pulls from a sheet that has prices and that all works fine. The Issue I am having is having the quantity determined based off of what is scanned. I was able to get it set to fill to “1” if it pulls a proper part number from the list. I cant find a way to tell it to merge its current quantity value and the one under it IF they meet two conditions: First one being that the part number is the same, Second being if the Equipment number is the same. 

For Example this screen shot when you scan it twice it puts two rows. I need it to read the two conditions of same “Barcode scan” and same “job number” so it can merge the quantity of 1+1

But it also needs to know if the value of the two merged is indeed merged so it can clear the second barcode scan so it doesn’t repeat endlessly.

​Hello, I have something I am trying to solve and have been searching all over. I have a sheet made to help keep track of stuff taken from the warehouse. We have a scanner that pulls from a sheet that has prices and that all works fine. The Issue I am having is having the quantity determined based off of what is scanned. I was able to get it set to fill to “1” if it pulls a proper part number from the list. I cant find a way to tell it to merge its current quantity value and the one under it IF they meet two conditions: First one being that the part number is the same, Second being if the Equipment number is the same. For Example this screen shot when you scan it twice it puts two rows. I need it to read the two conditions of same “Barcode scan” and same “job number” so it can merge the quantity of 1+1But it also needs to know if the value of the two merged is indeed merged so it can clear the second barcode scan so it doesn’t repeat endlessly.  Read More

​