hi,
i have a range Sheets("entry").range("c10:c300")
i want when i input data in above range then value automatically add to Name Range ("ABD") and Name Range ("ABE") but only unique value
for example
i add in range c10 = "ALAN" Then add "ALAN" To Name Range ("ABD") And ("ABE")
again
i add in range c11 = "BLAN" Then add "BLAN" To Name Range ("ABD") And ("ABE")
again
i add in range c12 = "ALAN" Then Don't add "BLAN" To Name Range ("ABD") And ("ABE")
thanx