vba most similar cell

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question



    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)


    if


    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

  • HEMATINSITE

    Changed the title of the thread from “ظطزپفغو.پ” to “vba most similar cell”.
  • 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