I still can not get the vba code to work, If anyone has any solution; vba code, formula, etc. Attached is the excel workbook and dot file and a word doc that is what the final result should look like when the merge data button is clicked. Any help would be greatly appreciated.