I am new to this site. I am trying to update my inventory using a scanner system. I am trying to delete old products and update new ones. I saved all the PLU info in the excel format. I want to automatically move left one column after data input by scanner.What I am trying to do is that when I scan the product's UPC code, it should find the product and go to next column where I can update the quantity, and then go to the next column where I can change the price. I worked wtih Excel before but I need help in this matter. I will be very thankful.