storage automation

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

Hi,

your problem is far too confusing and unfamiliar to have any realistic help. You need to simplify it and post a sample of precisely what you need.

this was an enormous job !!:D wow. i will have to sit down and look at it tomorrow and try to understand it! so i will replay more tomorrow!! thank you soo much so:D