Hi devs, I would like to compare if a row in sheet “a” is the same value with row in sheet “b” ,if true, remove matching rows from sheet “a”. Please assist
Read the sheets and store it in Data Table
ForEach row in dt_Sheet1.AsEnumerable IF dt_Sheet2.AsEnumerable.Where(Function(obj) obj("Column").ToString.Equals(row("Column").ToString)).Count > 0 Remove Data Row Else Do Nothing
Hope this helps
Thanks NithinKrishna. Regards
Perfect @RPA-botDev cool
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.