I hope someone can help creating a macro that would fill my word templates based off an excel template since it's a very repetitive and time consuming task.
Attached you will find everything needed.
Templates are located under Input folder and are completed based of "Data" sheet.
There are 2 templates, macro needs to ask before running which template should be used ( Do you need Logo?, Yes, No) and use accordingly.
Loops for each number and creates individual word documents based of number from column A and saves them under Output folder after each section was completed.
Word documents resulted should be saved as concatenate between columns B, C, & "CV" (LAST NAME, FIRST NAME, "CV", "with Logo/without Logo"). Last part depending on which template was used.
Word document may have up to 3 or 4 items in the same section for some No.: (see yellow highlights)
These need to be aligned.
Rows may be inserted if necessary, but template should be under <1 page.
Thank you for your time in advance, I hope this is something not too hard!!!