vba most similar cell

  • [xpost][/xpost]

    hi dears

    i need this vba code , please help us

    i have 2 excel sheet

    sheet x and sheet y

    sheet x have column b as product name and have 200 row

    i want in sheet x

    1-select b2 and find most similar cell in printarea in sheet y

    2-and then get price from next cell in sheet y (like in sheet y , a45 is most similar and must read price from b45)


    a) find 2 cells with same similar , read price from higher price cell

    3-get price and add with xpercentage in o2 or sum with z2 in sheet y and return price to sheet x cell c2

    4- repeat this ,for all column B in sheet x

    thanks for helping us

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. We are here to help so help us help you!

    Read this to understand why we ask you to do this

    A message to forum cross posters

Participate now!

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