How to copy and rename a template worksheet

[macca_18380]

Hi all and again thank you in advance,

I have a template tab which populates with a set of results based upon a macro which runs through a number of different scenarios. What i would like to do is copy the tab each time a scenario has finished its calculation and create a new tab whose name depends on cell C5 on the template tab.

Thank you again for your help
Michael

 

[mumps]

Use code tags to post the current macro you are using to populate the template.