Good morning,
I am currently using the following to locate a specific value "BFHOE" which is the name of a shift in a list - then copy the contents of a cell to the left of this value to another location. The problem I'm having is that this code locates BFHOE which is correct but also then finds BFHOEN which is a totally different shift and this is the one that is used to find the value that ends up being copied into the destination cell as it appears in the list after the intended search term.
Is there a way I can use the same code but define that I want only the exact term "BFHOE" to be located?
For Each cel In SrchRng
If InStr(1, cel.Value, "BFHOE") > 0 Then
cel.Offset(0, -3).Copy Range("F41:G41")
End If
Thank you in advance for any advice you can offer.
Jon
Bookmarks