How to search specific values in whole excel sheet

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.