Finding data successively in worksheet using a scanner

sueh63

New Member
Joined
Feb 19, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
  2. Web
Hi, I have searched the forums but haven't been able to locate a possible answer to my query, apologies if I have missed one. My scenario is that I have a spreadsheet of stock information sorted into columns with barcode number as one of the columns. Whilst I sit in front of the PC I want to see if a barcode is found in the spreadsheet when another person is scanning the barcode on the shop floor directly from the stock item. I don't want the action to change anything, just find (highlight the cell) where the barcode data exists and then move to the next "found" cell when the next barcode is scanned etc. At the moment I am using Find and Replace but if the scan finds the barcode, I have to click back on the find data entry box, clear what is there and then say OK so the next item can be scanned. Of course, if the item is not found, I would like notification of this, similar to the pop-up message generated when using Find and Replace. Any suggestions would be greatly appreciated, thank you.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,127,824
Messages
5,627,108
Members
416,222
Latest member
coloray13

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