- I have 2 workbooks with similar data. I want to vlookup all the values (each row) from WorkBook1 across all the values in WorkBook2 (all rows). I then want to write all the missing values to a new worksheet / workbook. (Im working with .xlsx)
For example,
WorkBook1
Sam
Danny
Rachel
Patricia
WorkBook 2
Sam
Rachel
Patricia
John
(The code should search for Sam across all rows of workbook 2. If it is found, it should move to the next row and look for 'Danny'across all rows. In this example, danny doesnt exist in WorkBook 2, and hence the code should write this entry to a new worksheet / workbook).
Im a beginner to VBA
Thank you!