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
Attachment | Size |
---|---|
Trial LookUp.xls | 54.5 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago