Good afternoon -
I have a workbook sheet1 that has a column (A) of defective serial numbers and column B which has "NG" in its cells, this is my lookup table. Sheet2 contains a column (K) populated from a barcode scanner, with an adjacent column (L) performing a vlookup to column A in sheet1. If a match is found, it returns the "NG" to the cell in column L adjacent to the the last scanned barcode and I turn the cell red; if no match is found I turn the cell green and label it with an "OK".
I would like to fill the cells in the lookup table (sheet1 column A) with yellow if they matched the scan results, so at the end of the day I can see what numbers are matched and what numbers are not yet matched. I am weak with VBA, what little bit I have added is from trial and error, with a healthy dose of Google results for inspiration.
Thanks for looking and for any suggestions!
I have a workbook sheet1 that has a column (A) of defective serial numbers and column B which has "NG" in its cells, this is my lookup table. Sheet2 contains a column (K) populated from a barcode scanner, with an adjacent column (L) performing a vlookup to column A in sheet1. If a match is found, it returns the "NG" to the cell in column L adjacent to the the last scanned barcode and I turn the cell red; if no match is found I turn the cell green and label it with an "OK".
I would like to fill the cells in the lookup table (sheet1 column A) with yellow if they matched the scan results, so at the end of the day I can see what numbers are matched and what numbers are not yet matched. I am weak with VBA, what little bit I have added is from trial and error, with a healthy dose of Google results for inspiration.
Thanks for looking and for any suggestions!