One way:

Worksheets("template").Copy _
after:=Worksheets(Worksheets.Count)





MrT wrote:

looking for an excel solution to create a new sheet at the end based on the
contents of a template sheet within the same workbook.

--

Dave Peterson