copy template

  1. R

    Cell driven macro to copy a template sheet to other sheets

    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...
  2. A

    Create Multiple workbooks, with multiple workshhets, containing a template

    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...
  3. D

    Macro to copy template, named based on cell value in order & allowing data to be added to original list

    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...
  4. J

    Sequentially Number copies of template worksheet

    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...
  5. S

    Create Excel file from a Excel Template programmatically

    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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top