![]() |
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. |
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