Thankyou Dave

Could you help with another question?

I am very new to excel and am trying to build a tool to help me define tasks
in my work day schedule.

Now I can create a new sheet 'on the fly' How would I copy the contents of a
cell in an existing sheet to a cell on the new sheet; and How would i rename
the new sheet based on cell contents?

MrT

"Dave Peterson" wrote:

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