Thread: New Tabs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bailey bailey is offline
external usenet poster
 
Posts: 22
Default New Tabs

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.