Hi.
I'm pretty green when it comes to macros, so hoping someone could help me out.
I want to check each number in the Number column of "OldData" sheet, and search "NewData" sheet to see if the number is present. If the number is NOT in the Number column of "NewData", then copy entire row that contains that number from "OldData" and paste at bottom of "NewData" sheet.
Is this very complicated?
So to try and summarize in steps:
1. Copy B2 of OldData sheet.
2. Find B2 (OldData) in NewData sheet column B.
3a. If found, move on to B3, loop back to step 1.
3b. If not found, copy Row 2, and paste in first empty row of NewData sheet. Move on to B3.
Big thanks in advance!
Bookmarks