Alberto,

Try some code like the following:

With ActiveWorkbook.Worksheets
Workbooks("Templ.xls").Worksheets("Template").Copy after:=.Item(.Count)
.Item(.Count).Select
End With

This will copy the worksheet named "Template" from the workbook "Templ.xls"
to the ActiveWorkbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"Alberto Pinto" wrote in message
...
How can I programatically (vb or macro) create new worksheets (ideally
based on a template) on my workbook and populate that new worksheets from
a list of data?

Thanks in advance