I have a set of code that is not extracting all the data correctly , only partially collects it correctly even though the find values are the same in both books. It is designed to lookup the peoples names in the dataCSV file and then post them next to the corresponding persons name in the sampleFind workbook. I have highlighted the peoples names that are not working after running the code. (The characters in column B on sampleFind workbook are peoples names BTW)
Edit: CSV files are invalid so I saved it as a .xlsx file. Cheers
Bookmarks