How to compare and sort datas in two tables?

[Haylie_Hoang]

Hi everyone! 

I'm analysing my data from my 2 separata excel work sheets but I have no idea how to sort and compare them. These are the 2 subscriber lists that I'm working on, I need to find out the missing data/information from the WOIA ALL list that are not included in the WOIA REGISTRA list, so that I can create a separate sheet for all those missing data. Please find in the attachments below. 

Thank you and looking forward to your guidance. 

[#2]

Perhaps you can import both lists into the same workbook and use my Compare2Tables tool from https://jkp-ads.com/download.asp#Compare2Tables