Copy template sheet and rename according to list

Hello there.

I am new to this Forum so let me know if there are things I can do to make my questions easier to answer. I am new to macros as well and am trying to learn how to use them for my current job. I am trying to figure out how to create copies of a template sheet that I have and rename that sheet according to a list. Two other things to take note of:

1) I would also like to be able to have the newly created sheet have data fields autofilled (like address, number of units...etc).
2) Once I have created the relevant number of copies I want to figure out how to link cells in each copy to a summary sheet.

I have attached my rough document and below included by attempt to just write the VBA to copy and rename the sheet, which did not work out well for me.

Please Login or Register  to view this content.

That is what I did exactly pasted from VBA. This did fine for one copy but I don't know how to modify it to work for the entire list. I am trying to learn how this works so, obviously direct code is helpful, but also explanations and recommendations of guides/tutorials are much appreciated.

Thanks in advance and let me know if I can provide more detail/information.ExcelForum Copy Template and Rename.xlsm

Please Login or Register  to view this content.

I am not sure what parts you want where when you say that you want to auto populate fields

stnkynts thank you for the help! The code works wonderfully, I don't really understand it in the slightest but will work to figure it out on my own.

Thanks for the quick reply. Do you have any tutorials you would recommend for a beginner?

There is a sticky on this forum addressing learning materials

http://www.excelforum.com/excel-prog...materials.html

I personally think the VBA For Dummies is a good starting point. Very, very, basic.