Multiple Find and Replace

Can someone please help me on this?

I have these columns on one sheet, with labels...
BR
BR
CAM
CAM
CAM
COW
COW

And on another sheet, I have each one, and what I want it to say in those column:
BR Pam Britton
CAM Joy Campbell
COW Bonnie Mohr

I guess basically like a multiple find and replace. I want to replace all BR's with Pam Britton, all CAM's with Joy Campbell, and all COW's with Bonnie Mohr. But there are hundreds of these. There must be a quicker way to do this.

I will now cease to ask, "Is this even possible?" I've found that pretty much anything is possible. You just gotta know how. Thanks for the help in advance.

Matt

myRange is the range of cell containing the data to be replaced, while rList contains the table with the values you want to replace.

Please Login or Register  to view this content.

Do forgive me, but how do I run that?

Alt+F11 to launch the VBE
Go to Insert / Module
Paste it in the window that opens
Press F5 or click the Run button.

Make sure you adjust the ranges and sheet names to suit your set up.