Automated XML,JSON, HL7 manipulation from rows in CSV file using Excel macros using VBA

This project can be done in excel micros using VBA Project explanation : I have set of xml's in 1 csv (also another set of JSON's in another csv and another set of HL7 in another CSV). First considering xmls in csv: Example: Say this excel attached has about 94 rows of xml's with duplicate id's. Some rows have id:160700 and those duplicate id rows first name and last name in xml column D should be updated to say Johnson and last name to say David and another duplicate set with id: 205066 first and last name should be changed to say Shawn Neil . If more duplicate id's are found then the logic should update first and last names in xml of others rows as well. Same for CSV with JSON and HL7 data in it. I will provide these 2 files with JSON and HL7 later.