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)


    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

    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!

Register Yourself Login