I need excel expert
Budget: $10 – $30 USD
Hi there,
My excel sheet has some data (as in attached sheet labeler 1)
-The items that we will be receiving are going to have barcodes/QR codes on the labels.
-Is it possible to scan the barcode/QR code (using a wired or bluetooth barcode scanner) from the package in cell C3 and enter the quantity manually in cell C2 and once the scan is done this excel sheet "labeler 1" automatically shows "Received" or "OK" with date & time stamp in "Received" and "Date of Receiving" columns in corresponding row for that particular item/barcode row and at every scan highlights the row preferably in a light orange color to show that quantity and barcode are entered correctly and that the item is received with the time stamp?
-Cell C3 should be able to scan both Barcodes and QR codes because column B can have either one of them
-Row 1 & 2 and their columns will always stay the same but the data underneath will be copied and pasted from other excel sheets in exact format for future receiving sheets for us.
Please write if it is possible, what would be the cost, time frame and mode of payment?
Thank you.
M.H.
My excel sheet has some data (as in attached sheet labeler 1)
-The items that we will be receiving are going to have barcodes/QR codes on the labels.
-Is it possible to scan the barcode/QR code (using a wired or bluetooth barcode scanner) from the package in cell C3 and enter the quantity manually in cell C2 and once the scan is done this excel sheet "labeler 1" automatically shows "Received" or "OK" with date & time stamp in "Received" and "Date of Receiving" columns in corresponding row for that particular item/barcode row and at every scan highlights the row preferably in a light orange color to show that quantity and barcode are entered correctly and that the item is received with the time stamp?
-Cell C3 should be able to scan both Barcodes and QR codes because column B can have either one of them
-Row 1 & 2 and their columns will always stay the same but the data underneath will be copied and pasted from other excel sheets in exact format for future receiving sheets for us.
Please write if it is possible, what would be the cost, time frame and mode of payment?
Thank you.
M.H.