Compare column to another column in different sheet and add different values to another sheet (TIGHT DEADLINE)

[annarose059 (Anna Lavis)]

HI all,

I have one worksheet with a set of values, and I want to compare this column to another column in a separate worksheet. For the values that don’t match, I want to add those values to a new worksheet. Can you help? So far, I can determine how to put the differents in a new worksheet. THANK YOU!

[aksh1yadav (AKSHAY YADAV)]

@annarose059

I have one worksheet with a set of values, and I want to compare this column to another column in a separate worksheet. For the values that don’t match, I want to add those values to a new worksheet. Can you help? So far, I can determine how to put the differents in a new worksheet. THANK YOU!

\Hey @annarose059

have you checked this thread?

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Regards…!!
Aksh