Hi Everyone,

Good Day!

Hope you can share some codes with my current problem. I have a
template with 5 sheets on it. I update this template once in while,
once updated i recreate close to 20 workbooks out of this template
with different file name when save.

I am thinking, is it possible if i have another "name sheet" on my
template with the list of all file names i need to recreate then run a
macro to duplicate my workbook template and get the file name on the
name sheet tab and the macro will run up to the last cell with name on
that name sheet.

Hope i explain it clear :) Thanks in Advance.

Tops