Hi,
I have a CSV file with a column of text "see attached"
I would like to scan barcodes on physical assets and highlight the equivalent barcode text in the CSV file if it exists.
I can highlight one matched barcode but I'm unsure how to keep the previously matched cells highlighted.
Thanks
Last edited by jmck147; 12-20-2022 at 05:11 AM.
I make barcodes at work all the time using Excel
There is usually a font that you download and you have to find one that is compatible to your scanners.
The one I use is IDAutomationC39XS
That said, when I make a barcode it has to be read between asterisks.
If you wanted to create a barcode SCAN in excel you would have to not only make it say *SCAN* that it would have to be in the font as I mentioned.
see attached.
Regards.
(I don't know if you will be able to see the font I used, you may have to download it, but the principle is the same)
Side note:
A CSV file is simply a text file. It contains no formatting. this is why you cannot highlight and share.
Last edited by thenewkidd; 12-19-2022 at 04:39 AM. Reason: EDIT TO ADD
Thanks thenewkid for your prompt reply however barcodes are not the issue it's how do I keep previously located fields highlighted?
When I scan another asset it only highlights the new asset in the spreadsheet
If you expect Excel to remember previous values, you'll need VBA. If that's OK, I'll move the thread for you. Otherwise, you'll need a rethink.
Let me know.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glenn, yes please move the thread; hopefully I can get some VBA code to resolve.
Moved. I cant help, 'cos I know nuffin' about VBA. Others do, and they'll help.
Could you use conditional formatting with a vlookup?
For instance, if you scanned the barcodes in to column F and applied this conditional format to the codes in column A to highlight them.
Formula:
Please Login or Register to view this content.
Thanks ByteMarks would you mind explaining how I add the vlookup formula to conditional formatting?
- Select the cells to be highlighted
- Hold Alt, then press H L N in sequence to bring up the add new format dialog.
- From "Select a Rule Type", choose "Use a formula to determine which cells to format".
- Enter the earlier formula the the box "Format values where this formula is true:"
- Click the "Format..." button.
- On the Fill tab, choose a highlight colour
- Click OK
- Click OK
Super thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks