Hello,
I have a membership spreadsheet. What I want to achieve is when the QR is scanned with the id number excel should find it and go straight to that line and highlight it.
I have managed to get that work by typing in the id but when I scan it, it just highlights and goes to the next line it doesn't go to the line where all the info is at.
Here is the code I used:
I have a membership spreadsheet. What I want to achieve is when the QR is scanned with the id number excel should find it and go straight to that line and highlight it.
I have managed to get that work by typing in the id but when I scan it, it just highlights and goes to the next line it doesn't go to the line where all the info is at.
Here is the code I used:
Excel Formula:
Cells.Find(What:=Sheet1.Range("a1").Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True _
, SearchFormat:=False).Activate