Hi Everyone,
What I am trying to do is this. for example in my sheet.. cell A24 needs an item# or SKU if you wish. Once that number is entered, I have cell B24 vlookup the description from another sheet and autopopulates it, also cell c24, looks up the price. Cell D24 is the QTY.
Is it possible for when an item is scanned or whatever # is entered in cell a24 that a pop up box comes up that says QTY, which forces the cashier to put in a QTY in my D24 cell, then it should go to line A25 ready for another scan or item number entered, and if that is true, then pop up box comes up again for QTY for cell D25 and so on.
if no more items is entered, then it prints, clears the info and ready for next customer
Please help if you know a way. Thank you
Andre
What I am trying to do is this. for example in my sheet.. cell A24 needs an item# or SKU if you wish. Once that number is entered, I have cell B24 vlookup the description from another sheet and autopopulates it, also cell c24, looks up the price. Cell D24 is the QTY.
Is it possible for when an item is scanned or whatever # is entered in cell a24 that a pop up box comes up that says QTY, which forces the cashier to put in a QTY in my D24 cell, then it should go to line A25 ready for another scan or item number entered, and if that is true, then pop up box comes up again for QTY for cell D25 and so on.
if no more items is entered, then it prints, clears the info and ready for next customer
Please help if you know a way. Thank you
Andre
