copy template

Hello! I'm looking for a macro that can create a new sheet for all entries in a specific column based on a template. I know how to run the new tabs with the correct names, but I can't seem to figure out how to make those new sheets a copy of the template. For reference, my master sheet with all...

Hi, folks, asking for some advice on how to do this. I have some vba code from another thread here, and was hoping more could be done while it's creating these sheets. My Data sheet has data in Cols A:H with Col C being the sheet name values. (see pic) What's needed is to copy matching...

I have a macro for copying a template worksheet and pasting it over specific sheets when a named cell (Overwrite_Sheetn) says "Yes". It's not elegant, and only works some of the time. For some reason some of the sheets won't copy and paste the template file. I have 20 sheets that can be...

Need help to solve a tricky situation: I have an workbook with two sheets: "sheet1" containing on column A the working days of a year and on column B the months of a year and sheet "Template", which contains a template (with formulas in it). (1)By clicking a button I want to (2) create 12...

Hi there, I'm a complete newbie at VBA, only looked at my first code this week! After searching many forums (thanks for your help everyone!) I have modified code to work somewhat. My macro currently copies a template and renames it based on data on my "estimate" sheet, what I need help with...

Hello, I am using the following code to create multiple copies of a template, based on the "number of copies required" which is determined by a formula in cell D10 on the "Staffing Plan" worksheet. If D10 = 5, then it will make 5 copies. It then renames the worksheets to give me: Report 1 of...

Hi, I have an Excel template and trying to create a copy of the Excel template programmatically. I would really appreciate if somebody can give some tips to how to get it done. Thanks, Antony