• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Compare and capture the values using VBA

P

Praneeth30

New Member
I want to take the fields of COLA of Sheet2 and do a lookup on COLA of Sheet1 and if i find it twice in COLA of sheet1 i want to capture the corresponding COLB value of Sheet1 and place it in COLB of sheet2. If i find the field twice in COLA of shee1 i have to display both the corresponding values of COLB of sheet1 to COLB and COLC of sheet2. I have to repeat it to each and every field.

P.S: I cannot use lookup functions as the values in COLA of sheet1 repeats for more than once and i have to capture all the related values of COLB of sheet1 and display in COLB of sheet1.

Please help here.
 

Here is the Excel formula forum, see in appropriate VBA forum
and according to forum rules with a sample workbook …
​
 
You must log in or register to reply here.
Back
Top