Find and Replace using ranges

[mmueller54]

I have a spreadsheet that I would like to replace the values on sheet "BCA_R2", column A using another sheet "ReplValues" which has the find and replace values. There will several hundred values to find and replace.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[mmueller54]

THANK-YOU! Your solution worked perfectly, no coding changes.