Worksheet_Change Event Add unique value to Sheets

  • 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

  • Re: Worksheet_Change Event Add unique value to Sheets


    Are ABD and ABE referring to those columns, a single cell, or a range of cells?

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

  • Re: Worksheet_Change Event Add unique value to Sheets


    Does it dynamically grow as we add values to it? I.e., if it refers to 4 cells currently and we need to add a 5th value, what should happen?

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

  • Re: Worksheet_Change Event Add unique value to Sheets


    No its not dynamic,
    ABD = Sheets("total").range("B4:B100") And
    ABE = Sheets("hide").range("C10:C100")


    if we need 5th value then add it to ABD and ABE but only if its a unique value, i mean if this value already not added to ABD and ABE
    thanx

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!