ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   New Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/177149-new-tabs.html)

bailey

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.

Barbara Wiseman[_2_]

New Tabs
 
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.





All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com