I am stuck at one point, please help me
I have 2 Excel sheets with same headers,
I need to do vlookup, I have huge date around 10000 in the excel.
I need to do vlookup from present date sheet to previous date sheet.
I need to do vlookup for the column
Please help me, it’s bit urgent
dt1.AsEnumerable.Where(Function(a) dt2.AsEnumerable.Any(Function(b) b("ColumnName").ToString.Equals(a("ColumnName").ToString))).CopyToDataTable
gives you the matched rows in both the tables based on your columnname
@Shiva_Nikhil I am getting error as The source contains no datarows
Please try to use the attached solution. Make sure to create project on VB, Window & check the activities version too.
SourceToDestination.zip (165.9 KB)