Remove duplicate values

[pwill]

Hi can anyone help?

I have values in cells "E4:K4" sheet1 that change when commandbutton2 is clicked.

Cells "E5:K7" sheet1 also have values that change

If any values in cells "E5:K7" match values in cells "E4:K4" when the command button is clicked then I want to remove these values from the cells "E5:K7" and continue the same process each time the command button is clicked until there are only 7 values left in cells ""E5:K7"

Any help would be appreciated

Regards

pwill

 

[pwill]

Ok no worries, it does look complicated I will try and simplify and maybe someone else will step in?

Thanks anyway much appreciated

pwill