Update second sheet fix data into first sheet

How to update second sheet complete data into above First sheet

Eg: Code 6782001597 and revelent data from second sheet need to update in first sheet.

Note: Second sheet data is always fix and update this data into first sheet

@satish.rathi59
Here are 2 solutions for you. Taking data table in sheet1 is dt_1 and the other one in sheet2 is dt_2.

  1. Use For each row concept
    Loop each row in dt_1.
    Loop the CurrentRow(“Code”) in dt_2. If a match with the value of first column in dt_2, update
    the value from dt_2 to dt_1. Remind to set clearly variable name for those 2 loops.
    Then write dt_1 into sheet1.
  2. Use data table concept
    dt_1 left outer join dt_2 by column ‘Code’.
    For each row, update those values: if dt_2.Territory is not null then update dt_1.Territory =
    dt_2.Territory.