I'm googled out.
Say for example i import a csv of stock due to come in and I want to mark it off with a barcode scanner. I wish to get the following results.
Imported files will include
Part Number A1:999 | Order Number B1:999 | Quantity C1:999 (these have been charged to us and I need to check them off at receiving) Using a barcode scanner. Received/scanned items in D2 Onwards
Now to make things tricky I may have several items with the same part number under different order numbers so I need it to pick one and check that off (FILL THE CELL) and I will often have larger than one quantity of an item ie 10x or 100x but we can input this manually but i want a scan to set the next cell over as 1.
Also i would like that if a match is made and it has an order number that starts with certain letters ie sy,bn,ja in the same row to make a sound.
Epic right
Say for example i import a csv of stock due to come in and I want to mark it off with a barcode scanner. I wish to get the following results.
Imported files will include
Part Number A1:999 | Order Number B1:999 | Quantity C1:999 (these have been charged to us and I need to check them off at receiving) Using a barcode scanner. Received/scanned items in D2 Onwards
Now to make things tricky I may have several items with the same part number under different order numbers so I need it to pick one and check that off (FILL THE CELL) and I will often have larger than one quantity of an item ie 10x or 100x but we can input this manually but i want a scan to set the next cell over as 1.
Also i would like that if a match is made and it has an order number that starts with certain letters ie sy,bn,ja in the same row to make a sound.
Epic right