Scan Barcode...compare against inventory...place X in cell when matched...automated

slave1spectre

New Member
Joined
Nov 4, 2019
Messages
11
<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9
https://fhexcelphotos.shutterfly.com/pictures/10

Hi All,

Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or functions.

PROJECT: I am in the process of trying to simplify our lead testing program with a large healthcare organization.

CURRENT PROCESS: Blank spreadsheet…scan a barcode that is attached to a wearable lead…barcode value is recorded and we scan the next item. This process provides no immediate or post testing validation. Validation is performed manually and isnt conducive to time management but with over 3000 leads to test and limited time to complete it isnt possible to do so on the fly.

FUTURE STATE: Spreadsheet with listing of current inventory…scan barcode through a user form…program auto compares against inventory, records scanned barcode, places an X marker in an adjacent cell to designate which units have been tested, records test date, and the preset test location. Ive already built the user form to preselect the location, date, and barcode textbox to scan into. Date of inspection is set through a DT Picker control. Im using a textbox instead of a cmd button in an attempt to keep the process automated instead of having to hit an enter button after each scan.

REQUESTING ASSISTANCE WITH: Writing the code to have the program auto-compare a scanned barcode against the current inventory and record a marker indicating that it has been tested. It will also auto-fill the preset values from the DT Picker and location boxes. Have attached two links above showing...1. #10 Snapshot of the UI where the user would preset the test location, date, and box to scan in the barcode. 2. #9 Snapshot of the excel form where data will be auto generated within the blue colored cells and compared against the values in column E.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,716
Office Version
  1. 365
Platform
  1. Windows
Cross posted https://www.excelforum.com/excel-pr...y-place-x-in-cell-when-matched-automated.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,127,958
Messages
5,627,850
Members
416,276
Latest member
kbhoops15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top