Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Auto Generate and name Worksheets from a list

E-Coli, on Tuesday September 2, 2008 07:33:35 PM
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
Reply to E-Coli  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
 Ivan-hoe, on Saturday September 6, 2008 06:26:18 AM
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

Results for

Question? No real Problem. Hello, I want to make a alphabetize song list and later add songs to the list. Now the added songs will be at the bottom. I want to be able to click somewhere like where it says "name" on a folder and it automatically alphabetizes the list. Does any... en.kioskea.net/forum/affich-1611-question-no-real-problem
NetBIOS name resolution Hello, What windows NT server service provides automated NetBIOS name resolution ? en.kioskea.net/forum/affich-3082-netbios-name-resolution
Generate a List of Text in Excel Hello, On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a list of the product names from worksheet 1 - but I want only one occurrence of the product name.... en.kioskea.net/forum/affich-14824-generate-a-list-of-text-in-excel

Results for

GnuPG : key commandsGnuPG : key commands Storage keyring Public Key servers Below is a list of main commands for operating GnuPG Generate double keys: gpg --gen-key List available keys: gpg --list-keys Exporting your public key: gpg --armor --export... en.kioskea.net/faq/sujet-839-gnupg-key-commands
What is PCI ExpressWhat is PCI Express? Intro How does it work The different PCI buses Intro PCI Express, also named as PCI-E or PCIe (formerly 3GIO, 3rd Generation Input / Output) is the ultimate evolution of conventional PCI bus. Unlike PCI which is... en.kioskea.net/faq/sujet-776-what-is-pci-express
Connecting to a Ftp server under Ms-DosConnecting to a Ftp server under Ms-Dos The ftp command allows you to get connected using command lines. Some of these options provide an automatic connection; this is done through a list of commands store on a text file. ftp -i ... en.kioskea.net/faq/sujet-727-connecting-to-a-ftp-server-under-ms-dos

Results for

Help with Loop in batch File using input from (Solved)Hi Together I try to scan some PCs remotely and do want to automize this task. I created a batch file doing a good job, however, it scans only one pc and then I do need to change the target system name. I now want to create a comma seperated list,... en.kioskea.net/forum/affich-15768-help-with-loop-in-batch-file-using-input-from
Excel autofilter stops filtering (Solved)Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. When I clicked the arrow there is no value... en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering
Messenger auto run problemHello,in my pc all messengers,like msn ,yahoo,aim,those are automatically run in the desktop.when i on my pc it will run automatically how i can disable that option,then in my pc when i browse the internet ,every page is automatically open a new... en.kioskea.net/forum/affich-10791-messenger-auto-run-problem

Results for

Download Auto InsultAutoInsult is a wholly amazing program. Although the name is productive a bit perplexed, it is not known whole vulgar software. AutoInsult is a generator of insults certainly, but with a bite of humor. It generates insults in a style Arab, Shakes... en.kioskea.net/telecharger/telecharger-203-auto-insult
Download Windows Live Messenger Windows Live Messenger is the next-generation MSN Messenger. It has everything you already love about Messenger—your contact list, emoticons, and instant access to your friends via text, voice, and video—plus new ways to connect and share photos... en.kioskea.net/telecharger/telecharger-47-windows-live-messenger
Download DeeEnEsDeeEnEs is a program intended for the users who want to have a name of unique domain for their machine.Certain sites offer names of unique domains, but it is necessary to update them each time you are connected. Then for an automatic updating, use... en.kioskea.net/telecharger/telecharger-474-deeenes

Results for

Sun Microsystems selects Taiwan's TSMC as contract makerA Sun Microsystems sign outside the company headquarters in Santa Clara, California. Sun Microsystems Wednesday named Taiwan Semiconductor Manufacturing Co (TSMC) as its foundry partner for a deal expected to generate 500 million dollars a year for... en.kioskea.net/actualites/sun-microsystems-selects-taiwan-s-tsmc-as-contract-maker-10130-actualite.php3
Fuel-cell cars still far from showroom: ToyotaKatsuaki Watanabe, president of Japan's auto giant Toyota Motor, gives a press conference at Japan National Press Club in Tokyo. Work is moving ahead to build a next-generation eco-friendly car running on fuel cells but it will take years to... en.kioskea.net/actualites/fuel-cell-cars-still-far-from-showroom-toyota-10201-actualite.php3
Sanyo says to team up with VW in hybrid batteriesJapanese businessmen walk past an advertisement board of Japanese electronics giant Sanyo Electric in Tokyo in 2007. German automaker Volkswagen AG will team up with Japan's Sanyo Electric to develop a lithium-ion battery for next-generation... en.kioskea.net/actualites/sanyo-says-to-team-up-with-vw-in-hybrid-batteries-10410-actualite.php3

Results for

Attacks - Password protection When connecting to a computer system, you usually have to enter a log in or username and a password to access it. This login/password pair thus forms the key for obtaining access to the system. While the login is in general automatically attributed... en.kioskea.net/attaques/passwd.php3
Operating systems - File formats and extensions Comment: The list below is not exhaustive and certain extension names may have several functionalities. As for the programmes proposed for using these files, they are not necessarily the only ones or the most appropriate ones. Extension Description... en.kioskea.net/systemes/format.php3
Microsoft Windows 95 - Easter Eggs What does an Easter egg have to do with computing? "Easter egg" is the name given to inside jokes by programmers, who enjoy adding small and unneeded (but humorous) hidden features to their program (often the list of the program team, and sometimes... en.kioskea.net/win/winegg.php3