How to remove Duplicate row Based on "person number" from Two different data table While looping through

you can use a VB script also to delete it.

Attached the script in the code in new sequence, you can use that.

Make sure you do the necessary changes required for running the macro. You need to update the below setting in Excel Settings


File: (23.8 KB)

Hope this should help you resolve your query. If so, mark a post as solution to close the thread