On Saturday, July 9, 2016 at 12:59:51 PM UTC+1, Claus Busch wrote:
Hi,

Am Fri, 8 Jul 2016 23:33:33 -0700 (PDT) schrieb :

I took the code below from SpreedsheetGuru, but want to tweak it for my specific needs and I am a little lost

what are you searching for and what is the replacement?


Regards
Claus B.
--
Windows10
Office 2016

I have 2 columns in Sheet2 (the Table ref in code) ColA is the originating values that I require to replace with what is in ColB

The Data I require to replace in in SheetABC ColB