Comparison Formula error using vba

[Imran/CVT]

Hello All,

I am using below vba macro that looks in D column cell values and equates/ copy pastes in Col A those values that are available in Col D but not in A. After using below formula, I however get missing values in Col A but additionally getting 0's in Col A. Please help me to correct this error. OR Is there any way using vba to get desired results. Thank you

Examples of before and after using formulas are shown in figure

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administraive note
Please use code tags (#) instead of PHP tags.
Thanks

[Imran/CVT]

Edited original post

[Imran/CVT]

AnyOne