comparing the sheet 1 coloumn data with sheet 2 coloumn data

Question

hi, i have two sheets sheet1: A

Candesartan, apririn, drug xyz eee, drug abc aaa, drug lkl, drug aaa, drug bbb, drug ccc Livalo, anotherC, anotherD, AnotherE, morea, moreb, morec, mored, moree, moref, moreg,drug,

sheet2: A drug abc drug a drug b drug c drug abcd

i ahve to comapre these two and insert the sheet1 value that is not exist in sheet 2.

Answer 1

You can use Microsoft Excel ODBC driver to create two data sources for the worksheets and then use an ODBC data comparison/sync tool such as Zidsoft CompareData to compare/sync the worksheet data. Note that MS Excel ODBC driver would allow you insert but not delete/update worksheet rows.