HighFidelity
New Member
- Joined
- Nov 21, 2014
- Messages
- 1
Hi guys,
I am looking to optimise my product check-in and out system by investing in a barcode scanner and using it with Excel.
I would appreciate some help by having a macro running on my spreadsheets. I have an enormous list of barcode numbers, and all the associated details for ranges of product in a spreadsheet, and currently have to find the product by looking at the EAN, manually searching for it, and then navigating across to the "date recieved" column and manually inputting the date. I need to do this twice for each product.
I am looking for a macro which: when it recieves an input from the scanner, searches and navigates to the row where the product is, and if the same barcode has a second scan within 3-5 seconds, fills in the date in column x, and if column x is an occupied cell, fills in the date in column y.
This will allow me to both search for the product without filling in the date (not double scanning) for general lookups, but also to check the product in and out with the date.
I would massively appreciate your help, as I deal with over 10,000 unique products a year by myself and I'm trying to timesave wherever possible!
Thank you so much in advance for your help and advice,
James.
I am looking to optimise my product check-in and out system by investing in a barcode scanner and using it with Excel.
I would appreciate some help by having a macro running on my spreadsheets. I have an enormous list of barcode numbers, and all the associated details for ranges of product in a spreadsheet, and currently have to find the product by looking at the EAN, manually searching for it, and then navigating across to the "date recieved" column and manually inputting the date. I need to do this twice for each product.
I am looking for a macro which: when it recieves an input from the scanner, searches and navigates to the row where the product is, and if the same barcode has a second scan within 3-5 seconds, fills in the date in column x, and if column x is an occupied cell, fills in the date in column y.
This will allow me to both search for the product without filling in the date (not double scanning) for general lookups, but also to check the product in and out with the date.
I would massively appreciate your help, as I deal with over 10,000 unique products a year by myself and I'm trying to timesave wherever possible!
Thank you so much in advance for your help and advice,
James.