Barcode scanning application

[Rafi_2490]

Hi
Hope you are doing well!!
I need to create an excel sheet for store support.
Application details:
I have a material which has a QR code and some Location racks with QR Code.
Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in Excel with date and time.
Need your help with respective VB coding or with any other possibilities.

Thanks
Rafi

 

[RasGhul]

Hi Rafi,

So when you scan a barcode does the barcode number appear in the selected cell?

If you had an SKU list of all your data including rack locations you could do a lookup for the product data with time stamp an user ID etc then use VBA to add this row to a table of transactions for inventory movements etc?