Generate excel workbooks based on list

[ysherriff]

I have an excel template that I would like to:

1. generate duplicate copies based on a list
2. save that copy with the individual name in the list.

I have attached two files: 1)the template and 2)the template generator.

The generator has the list name. I have started the macro but running into roadblocks. Anyhelp would be appreciative. I am learning VBA.

 

[Abdul Matheen]

Hi,

As per you query check the attached workbook, you not need to create a separate workbook for the list, just you can add one sheet into the template, i have created the "control" sheet in the template itself for workbook names.

Just run the Macro WBKDUP from the template, it will create the duplicate workbook with name list and save in the same location where the template is saved.


Regards
Abdul Matheen

 

[ysherriff]

Thank you very much Abdul. I will review the macro and learn from it.

I appreciate it sir.

 

[ysherriff]

Abdul,

Great job. I have a question. I created a name range "DSM_NAME" for the page header/title on the "Activity" tab. I want to know how can i change the page header/titlee to have the name of the list added to the title. For instance, if it is creating a workbook for Atlanta then the page header/title should read:

Atlanta Direct Connect Activity Reoprt

Thanks for your help. I have updated the file again.

 

[Abdul Matheen]

Hi,

Find attached workbook with updated changes as per your request.

Regards
Abdul Matheen

 

[ysherriff]

Thank you Abdul.

 

[ysherriff]

Abdel,

What does this line in the code do? I am trying to learn it.

Do While Sheets("control").Cells(i, 2).Value <>

Can you do me a favor and put comments next to the line so i can now what each line does? I am really trying to learn VBA.

Thanks

I have uploaded the file.