In my project, I am searching through a column that would have data as follows:
I want to match the values with a column from another worksheet that would have the following:
If a match is not made, the row is to be hidden on the original sheet.
The code works fine when i put the complete number in the column in the other sheet, however, I want to be able to match based upon just the first four.
I have attached my code snippets below. The line highlighted in red is my issue. I have tried
Both to no avail, hiding all of my rows.