Hello,

I am struggling to create a macro to copy/paste value from sheet A to B.

I have sheet A which is my master and I would like to copy/paste the values from column D6, G6-K6 and R to lastrow to sheet B but only if the value in Column D6 to lastrow doesn't exist in column A6 to lastrow in sheet B.

Any help would be really appreciated as I have been trying to find a solution for quite some time now.

Thanks,

gv