Search From List - Macro

[CONFUSED_AS_USUAL]

Hi,

I know how to search the contents of a cell that contains a specific string and replace it. However, I do not know how to do this using a macro with a list for multiple searches.

However, I would like the same thing done, but from a list.

Example - worksheet1

A B
1 bghmondkj MTL
2 98&^Tor89)( TOR
3 (*^CbhKHJ CHI
4 bru79087kll BOS

List would be on worksheet2... something like this:


A B
1 mon MTL
2 Tor TOR
3 cbh CHI
4 bru BOS


It's probably something kind of simple, but it's beyond my knowledge.

Thanks

 

[CONFUSED_AS_USUAL]

Sorry, hopefully this is a bit clearer....

	A	B
1	bghmondkj	MTL
2	98&^Tor89)(	TOR
3	(*^CbhKHJ	CHI
4	bru79087kll	BOS
	List would be on worksheet2... something like this:
	A	B
1	mon	MTL
2	Tor	TOR
3	cbh	CHI
4	bru	BOS

<tbody>
</tbody>

Hi,

I know how to search the contents of a cell that contains a specific string and replace it. However, I do not know how to do this using a macro with a list for multiple searches.

However, I would like the same thing done, but from a list.

Example - worksheet1

A B
1 bghmondkj MTL
2 98&^Tor89)( TOR
3 (*^CbhKHJ CHI
4 bru79087kll BOS

List would be on worksheet2... something like this:


A B
1 mon MTL
2 Tor TOR
3 cbh CHI
4 bru BOS


It's probably something kind of simple, but it's beyond my knowledge.

Thanks