Good afternoon,

I have this code that looks for telephone numbers in (Sheet A) matches the telephone number in column A (sheet 1) and replaces the value from column B (sheet 1) which in this case is nothing but what i want to do here is the opposite and need some help adapting my code. What i want to happen is to keep all numbers that exist in column A sheet 1 and remove anything else.

Please Login or Register  to view this content.
Thanks in advance

DJ