Macro to find and mark cells

[elgato74]

Dear All,

please have a look at the attached workbook.

On Sheet 1 in Column "O" I have item names.
On Sheet 2 in Column "A" I have 3-letter codes.

Notice that the item names end in a 3-letter-code followed by a -suffix.

The macro should check if the 3letter code is contained in the item name, and if so, it should mark it with an "x" in Column "N".

In my sample, 3letter code BYA was contained in cell O2, so it marked with with an "x" in N2.

As my real Workbook has 20,000+ rows, I think a macro would be better than formulas.

Thanks in advance.

[PCI]

We need to check only the 3 letters code before the "-" like BYA in O2 , not the full string ??

[elgato74]

yes, that is correct

[dangelor]

Possibly...

Please Login or Register  to view this content.

[PCI]

See next code

Please Login or Register  to view this content.

[elgato74]

Hi PCI

thank you! So far so good. But I am sorry, not all items in "O" end with a 3 Letter code + -suffix. The macro stops if an item has not a 3Letter Code or if it ends with a 3Letter code without -suffix.

Can this be fixed?

[Leith Ross]

Hello elgato74,

This worked for me on the workbook you posted and with the changes you mentioned.

Please Login or Register  to view this content.

[PCI]

Okay, specifiactions change a little bit, so try next remake

Please Login or Register  to view this content.

[elgato74]

Thanks guys !!

All solutions worked like a charm for me. Muchly appreciated !

[PCI]

Another code which could go faster when there is a lot of rows..!

Please Login or Register  to view this content.