I am collecting information on people and what products they use.
In this case, I will be using SoftwareSurvey.xls.
***But, I want to be able to select the file that will be duplicated***
The list of people is People.xlsm
The macro will create:
In each of the created xls files, Sheet1 should be renamed for the person and cell B1 should get their name as well.
I want to run the macro in People.xlsm and be asked for what file to be duplicated with their names.