Dears,
How To Update One Column Based on other Columns from different Workbook ( Update Column 4 Based on Column 1 &2&3, Knowing that Column1 & 3 are sharing some data as shown in below example) :
Note : Workbooks attached here for reference
Book1.xlsx (10.0 KB)
Book2.xlsx (9.9 KB)
Important : I want to keep formatting of Workbook 2 , Otherwise I can use Join Activity, Probably LINQ or Select Methods can help but I don’t know how to apply the same in this case.
Thanks in advance