I have list file in xlsx form containing 200 names from A2:A201
I have one excel template file .
What I require is to create multiple files by using the above mentioned template, picking name one by one from the List file - inserting the name at cell B2 of template file and save the file with the name taken from the List. Saving files in xlsx form.
All created files to be saved in any given folder.
Please if possible