I use a barcode scanner connected via Bluetooth to scan asset tags (barcodes) into a spreadsheet. Afterwards I would to use the spreadsheet to conduct a physical inventory of various locations using a list of values.
My goal: Scan a barcode and have the Find function Locate and Highlight the cell if the value is found in the list. If the barcode is scanned and the value is not located in the list, I would like the value to be added to the list (sheet).
My question: Is there a function to find and highlight values in a list? If the value is not found in the list, is there a method to add the value to the list?
Thanks,
ZJ
Bookmarks