I have to take one ‘cell’ value from one excel sheet(row by row) and i have to search that value in another excel sheet,if found i have to paste the remaining columns data for that row in destination excel sheet.
Thanks
Anantha
2 Likes
Can someone please help on this question.
thanks in advance
Hey there @Ananthaeswar2!
In excel, you need to know column names, so you can do this
if(out_dtAccountData.Select(“UniqueID=”+in_strUniqueID).Count > 0, False, True)
out_dtAccountData is from reading the excel
UniqueID is the column name
in_strUniqiueId is the value you are searching
Hope this helps.