Search : in
By :

Auto Generate and name Worksheets from a list

Last answer on Oct 22, 2009 6:10:06 am BST E-Coli, on Sep 2, 2008 7:33:35 pm BST 
 Report this message to moderators

Hello,

How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begins at cell A10. Mind you, this list will vary from workbook to workbook. Do you have some code already compiled to perform this?

E-Coli

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « Auto Generate and name Worksheets from a list » in :
Download Random Number Generator Pro Show Random Number Generator Pro is a tool that generates a list of random numbers based on customizable criteria. You can choose the minimum and maximum limits and incrementing numbers. Limits can be positive or negative values. Advantage The...
Download Recovery for Oracle Show Recovery for Oracle is a tool to restore damaged data from an Oracle database . It can also restores backup objects including views and stored procedures . It can work manually or by using an auto-generated rebuild batch file. Advantages The...
Generating random numbers with rand() ShowGenerating random numbers with rand() You may have noticed when using the rand() found in the standard library of C language, you often get unsatisfied by the results, they look the same. For example, when trying 5 random numbers in...
Unable to delete file: Argument list too long ShowUnable to delete file: Argument list too long Solutions Xargs Command find loop for (bash) Program Perl When trying to delete a file , you receive the following error message : bash: /bin/rm: Argument list too long This is...
List of open ports in command line ShowList of open ports in command line Whether you're running Windows or Linux / Unix, the following command in (console) will display the list of open ports on your computer: netstat -a For the use of advanced graphics tools, see What...
Download WIFI Key Generator ShowWifi Connections are certainly very practical, but given that they require no wiring, everybody can be connected to it if his computer is compatible with Wifi. WIFI Key Generator is a small application intended to generate random protection keys for...
Download Random Number Generator Pro ShowRandom Number Generator Pro is a very simple tool to generate a random number list. There are several combinations and you can define the randomization criteria. You simply select the lower and upper limits as well as the number increments and the...
DNS (Domain Name System) ShowWhat is DNS? Each computer directly connected to the Internet has at least one specific IP address. However, users do not want to work with numerical addresses such as 194.153.205.26 but with a domain name or more specifically addresses (called...
Windows Processes - Introduction ShowIntroduction to Processes To make it more versatile, Microsoft Windows is structured around services (processes) which run in the background. The list of processes currently running may be viewed by pressing CTRL+ALT+DEL simultaneously, then...

1

Ivan-hoe, on Sep 6, 2008 6:26:18 am BST

Hello E-Coli,
apparently my tips did not help you.
anyway, here is a solution :

Sub CreateSheetsFromAList()
    Dim MyCell As Range, MyRange As Range
    
    Set MyRange = Sheets("Summary").Range("A10")
    Set MyRange = Range(MyRange, MyRange.End(xlDown))

    For Each MyCell In MyRange
        Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
        Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
    Next MyCell
End Sub

I.

Reply to Ivan-hoe

3

 siva, on Oct 22, 2009 6:10:06 am BST

Please let me know where exactly script shouldbe done becus i am not familiar with macros but i would like to create sheet name for about a year datewise from the month of NOV 2009 in a single work book or atleast for a period of 3 months

pls reply immdtly

thanks

Reply to siva

2

tuta, on Mar 25, 2009 7:00:30 pm GMT

Hi

It was really useful your formula but I would need the others worksheets to be equal to the first one. I've trying to do it but i wasn't able to do it. Can you help me one that?

Reply to tuta