Hi All,
I need a macro to copy a file in a folder and make multiple copies of it in that very folder.
Step 1 : Select the file you want to make copies of.
Step 2 : Select the destination folder / auto select it based on the folder of the file in Step 1.
Step 3 : List all the filenames in Column A starting from Cell A2 (Header Cell : FILENAMES)
Step 3 : Run Macro that will pick up the filenames listed in a column starting from Cell A2
and create multiple copies of that file with the names in Column A.
This macro should loop till the end of list in Column A is reached.
** The files can be of any type.
I need a macro to copy a file in a folder and make multiple copies of it in that very folder.
Step 1 : Select the file you want to make copies of.
Step 2 : Select the destination folder / auto select it based on the folder of the file in Step 1.
Step 3 : List all the filenames in Column A starting from Cell A2 (Header Cell : FILENAMES)
Step 3 : Run Macro that will pick up the filenames listed in a column starting from Cell A2
and create multiple copies of that file with the names in Column A.
This macro should loop till the end of list in Column A is reached.
** The files can be of any type.