Good Day
I wonder if you could assist me creating a scanning system to varifiy that my operator has the correct part.
Colum A,B and C are sent to me. I want to be able to scan part into D2 automaticly the excel must check the first 10 digits, if they match, colum E must display green OK and scanning area must then move to D3.
If no match is made the scan area must stay in D3 until the the correct part is scanned.
manual sequencing.JPG
Last edited by coolvibeguy; 04-25-2017 at 09:26 AM.
Try this in cell E2, and drag down.
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thanks for the If Code=IF(LEFT(C2,10)=LEFT(D2,10),"OK","NOK")
It worked great. I need to change the column format to text to show the full 20 digit.
Is the anyway to add to the code that when OK the cell or even the row will turn green and NOK will turn red
Look at conditional formatting.
See link: Format Row Based on One Cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks