Write an Excel Macro

Hello, Freelancer! I need Excel Macro to text manipulation I have a couple of hundreds strings with names and surnames, separated by commas. String can contain various number of names Also I have a separate spreadsheet with names , surnames and unique ID's What I want from macro: 1. Lookup for each name and surname in second spreadsheet and, if found, return concatenated ID, name, surname – in the same row , different column with only up to five first records 2. If Name not found in second spreadsheet – add it to this spreadsheet, and also return value to previous line with concatenated ID. Second spreadsheet already has a more than 700 names, so we cannot start making a new spreadsheet In attachment you will find all files about project description and data