• 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


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

Need code to analyze the data between 2 sheets and if same value is in cell A1 then it needs to check cell B2 and update data in sh1


New Member

Need code which performs the below operations.
Info :
I have two sheets with data in an excel. The data in both the sheets will be in same format.
Sheet 1 will be having header.
Sheet 2 will be without header.
Operations to be performed:
1. Value in sheet 1 Cell A2 needs to be checked with value in Sheet 2 entire column A.
2. If the value is matching then it needs to check the adjacent cell value (column B) in both the sheets.
3. If the value in sheet 2 is greater than the value in sheet 1 then the entire row (from column B to column Z) needs to be copy paste to sheet 1.

Thank you