Results 1 to 8 of 8

Dynamically creating new sheets when data is added to a column

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2017
    Location
    Landau
    MS-Off Ver
    2010
    Posts
    47

    Dynamically creating new sheets when data is added to a column

    The following code creates a new sheet with a for every value on the "C" column from the "Zuordnung" sheet and renames the sheet with the contents of the cell.
    However, if I want to make it dynamic, i.e. for a new sheet to be created every time I enter an additional entry in the column, what is the best way to do so?

    Sub Temp_Gen()
    
    Dim MyArray As Range, Mycell As Range
    Set MyArray = Worksheets("Zuordnung").Range("C10")
    Set MyArray = Range(MyArray, Worksheets("Zuordnung").Range("C32000").End(xlUp))
        For Each Mycell In MyArray  'Generating the Template Sheet
            Sheets("Temp").Copy After:=Sheets(Sheets.Count)
            Sheets(Sheets.Count).Name = Mycell.Value
        Next Mycell
    End Sub
    Any help would be appreciated!
    Last edited by hegdep; 07-13-2017 at 05:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dynamically changing indirect formulaes when columns are added to sheets.
    By Newbuilder in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2016, 02:22 PM
  2. Creating auto populating Summary sheet as new sheets are added to work book
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 05:01 PM
  3. Creating dynamically sheets with data and template
    By Fulla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2011, 02:40 PM
  4. dynamically added rows
    By johnzm in forum Excel General
    Replies: 6
    Last Post: 05-16-2010, 07:05 AM
  5. creating a subtotal for a dynamically sized column
    By Galoredk in forum Excel General
    Replies: 2
    Last Post: 03-02-2010, 06:22 PM
  6. Can Sheets be Added/Renamed via VBA dynamically thru the Main Sheet- Sheet 1?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2009, 08:47 AM
  7. creating pop-up menu from dynamically generated column values
    By bcamp1973 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-12-2007, 01:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1