Create multiple copy of a excel file and rename base on list

[kakero]

Hi . I want to make 24 copies of a excel file and name each of files base on a list in another excel file . Here is my list of names

is there anyway to do it ?

Thank you so much

[Mumps1]

Make sure that both workbooks are open. Place this macro in the workbook containing your list. Change the file path (in red) and name of the file to be copied (in blue) to suit your needs. The macro assumes the list is in column B and starts in row 2 and that it contains dates.

Please Login or Register  to view this content.

[kakero]

Thank you so much

[Mumps1]

You are very welcome.