Tricky: Macro to compare cells of two sheets, no exact matches though

[elgato74]

Dear All,


please have a look at the attached Workbook.

The task is to compare the contents of the first sheet "Ship" column B with the contents of the second sheet "Data" also column B. If it finds any of the words on the second sheet, it should pull the amount over to the first sheet and lastly, delete that entire row in sheet "Data"

I have manually entered the amount of 34,98 into the "Ship" sheet so you can see what needs to be accomplished. The tricky thing is, that there will almost never exact matches.

I hope anybody can help me with this.

Felix

[pjwhitfield]

Your data in Ship column B is never going to match with Data Col B as it contains the full name and address while Data is just names. Are you wanting just the names checking?

[elgato74]

yes, just the names. Comments in Ship can be ignored

[6StringJazzer]

elgato74, we do not permit posting of personal data. Your file has personal data in the comments. I have removed your attachment and reattached it without the comments.

[HaHoBe]

Hi, Felix,

this is the best example that you would need to normalize your data. Except having upper case as well as proper case names (can be handled with UCase or LCase) you have single names (what should they compare to: First or Last), firstname blank lastname, firstname comma blank lastname, firstname comma lastname, lastname blank firstname, lastname comma firstname, lastname comma blan firstname. This is no job for a programmer to help but for somebody who will make the data workable and the ask again.

And I don愒 think any title like Dr. should be part of a name.

Ciao,
Holger

[elgato74]

Hi Holger,

I was fearing that. To normalize 1,000+ rows is a bit of a pain. I was hoping that a search could do the job ... let's say 4 letters match - and boom that is a hit then

Felix