storage automation

[Sephre]

Hello. i`ve made a storage excel worksheet that we use at the factory i work at, but i want to automate it a little. and then my question is: is it possible if we Scan a number and then autoselect a cell in exel ? with some condition`s .. lets say that product number 850 will only be placed in A3 to D8, and the cell needs to be empty ofc, and that it counts the scanned pallets and posts the number of pallets up to 15 on the row it selects? after 15 it changes to another cell since out storage got 15 pallets pr row.. i attaced the store program, today we write the information in sheet 1 , and it shows in sheet 2