How to compare columns in different sheet and copy the rows which no match
I have a documents where i need to use a macro to retrieve information in sheet 3.
Sheet one is having two columns which needs to be compared with sheet 2 and where the match is not found, that row needs to be listed in sheet 3 first. The place where match is found needs to be listed after the previous task is completed.
How to compare columns in different sheet and copy the rows which no match
===

I have a documents where i need to use a macro to retrieve information in sheet 3.
Sheet one is having two columns which needs to be compared with sheet 2 and where the match is not found, that row needs to be listed in sheet 3 first. The place where match is found needs to be listed after the previous task is completed.