Is it possible to create new tabs and tab headings dynamically, thereby
creating a new worksheet for every entry? By that I mean, can I enter a list
on one worksheet with the names of the tabs/worksheets I want to create and
have Excel create new sheets (from a specific template) as I enter them? I
have a estimating form I am working on that I want to only create as many
individual element worksheets as I enter in the main form. Any thoughts would
be appreciated.

ASAP utilities has a utility to add sheets with names based on text in
selected cells, based on a template from another sheet
http://www.asap-utilities.com/
That may do what you want.
Barbara


"Bailey" wrote in message
...
Is it possible to create new tabs and tab headings dynamically, thereby
creating a new worksheet for every entry? By that I mean, can I enter a
list
on one worksheet with the names of the tabs/worksheets I want to create
and
have Excel create new sheets (from a specific template) as I enter them? I
have a estimating form I am working on that I want to only create as many
individual element worksheets as I enter in the main form. Any thoughts
would
be appreciated.