CONFUSED_AS_USUAL
Board Regular
- Joined
- Jul 6, 2017
- Messages
- 59
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
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