I need help for my problem. I need to compare data in two different excel and write the data the first excel with not exist in the second excel. I already saw the post How to compare rows in two different excel and already tried to adapt for my case but I receved the error “table doesn´t have a primary key”, someone can help me? in resume i need:
read the first excel
read the second excel
validate if the information in first excel already exists in second excel
if not exist the data are different should be write in a new excel
pls see my test in attach.
Thanks,NOTcontains.zip (18.2 KB)