Copy and Paste Unmatched Values in another sheet

Hello,

Please see an attached spreadsheet that contains a Macro that will run a VLookUp to seek for the matched values. The unmatached values will come as #N/A. The goal is to after running the macro to not only find the matched and unmatched values but to copy and paste the unamatched values in another sheet.

I am able to get the look up function to work. But my only remaining challenge is to get the code that will copy and paste all the unmatched values. Basically, the 3rd table (from Column AA to Column AD) will tell us what are the unmatched values between Table 2 (Column U To X) and Table 1 (Column A To P). All is needed is to get those unmatched values from Table 2 to be copied and pasted to sheet2. I have attached a copy of the spreadsheet called Trial LookUp. Please note that the original sheet is way bigger but the layout is identical. Please run the code. It would be great if you could help getting the code that will copy and paste all the unmatched values from Table 2 to sheet2.

Thanks

Michael

AttachmentSize
Trial LookUp.xls54.5 KB