Search for matching cells in table

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Or direct cell reference.

Please Login or Register  to view this content.

I suspect, you may need to change the AND into OR

AB33, thanks for your help.

I removed the "as string" and "as long" and that didn't seem to change anything except remove the 'type mismatch error'; now the code runs for a few seconds then stops without anything having happened.

I also replaced the variables with direct cell references and that didn't change anything either.

What do you mean by changing AND into OR? The search I'm doing needs the AND because all three column values have to be true so that the row can be copied.

Neek13,
Okay, do you have exact match in sheet column B with the other columns? What sort of data do you have in column B?
It would be easier to solve it, even improve the code if you could attach the sample you are working on.

Yes, the match is exact.

Sure, here's a sample workbook. The macro is in Module 1.

neek13,
I have not looked in details, but your code looks correct. There are no obvious errors, but I am wondering if there is a match in a single row (All 3 of them),hence there is no error on the code, neither there is a match.

The way I tested it this way. Put each if statement on a separate line and see if all could match. The code finds for example, the first 6216. The code will not find 6216, until row 68, so the code will return nothing until that line. From there, it tests B07582 and the so on.

Please Login or Register  to view this content.

The first cell with value B07582 is found in 6580, which means the code will be false until that row.

Yes.

I tried running it with the three if statements but still nothing happens. There are several rows that have all '6216' 'B07582' and '180'...

This worked perfectly fine when I was looking for solely numerical values, but it basically doesn't find it now that there's text involved.

Okay! give me a couple of minutes for testing.

Found the problem; you had spaces, so I used trim.

That's awesome! I never would've noticed that. The table is from a query that gets updated so I never would've thought to check it.

Thank you so much!

Neek13,
Data imported from other systems and website have lots of unseen and dirty characters. You should first clean the data before using the data in excel. One way would be to copy and paste VALUES ONLY. Delete the imported data from your book and work on the clean one.

You are welcome!