Hi there,

I'm pretty new to macros and I've been trying to do the following:

I have a sheet with codes, such as

abc-1
abc-12
bca-65
and so on...

And I need to lookup those codes in another sheet, where those codes are in cells, such as:

abc1-, abc-12, cba-45, aaa-1, mvn-98, etc etc.

Other cells have similar values as well, so I need a macro that finds those codes and remove them from the cells in the other sheet. I'm using Excel 2010.

Thanks in advance everyone.