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.
- 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. - 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.