msampath
04-06-2016, 02:11 AM
Hello All,
I want to restrict the duplicate entries in the entire row,this should also work when we copy and paste cells.Kindly provide me solution
Example:
Suppose the Range is A1 to AC1 then if A1 contains sam(correct) ,b1 contains sam1(correct),c1 contains sam(Incorrect) so i should restrict c1 by entering duplicate values need to check untill AC1.
Thanks & Regards,
Sampath
I want to restrict the duplicate entries in the entire row,this should also work when we copy and paste cells.Kindly provide me solution
Example:
Suppose the Range is A1 to AC1 then if A1 contains sam(correct) ,b1 contains sam1(correct),c1 contains sam(Incorrect) so i should restrict c1 by entering duplicate values need to check untill AC1.
Thanks & Regards,
Sampath