+ Reply to Thread
Results 1 to 3 of 3

Table DropLists not adding automatically to new rows

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    824

    Table DropLists not adding automatically to new rows

    Have a Table of records for April with DropLists in Col L.

    When I added data for May in Cols A - K the DropLists carried down each new row in Col L automatically.

    When I added the data to the same columns for June, the DropLists didn't carry down automatically!

    Sure I didn't do anything different, but can't find anything about this online.

    Any solutions suggestions or alternatives welcomed as ever

    Ochimus.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: Table DropLists not adding automatically to new rows

    Hello,

    check that your data is an Excel Table, inserted with Insert > Table or Ctrl - T.

    Make sure that you enter new data into the next row below the table. If you leave rows blank, the table will not automatically expand.
    One way to add a new table row is to select the bottom right hand cell of the table, then hit the Tab key. That will create a new table row with all formulas and data validation.

    If you have already entered the data and it is not included in the table, you can click a cell in the Table, then Table Tools ribbon > Resize Table and enter or select the range for the table.

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    824

    Re: Table DropLists not adding automatically to new rows

    teylyn,

    Appreciate the prompt pointers.

    It is an Excel table created as "insert Table", new data is added automatically to the next free row, and the new rows are included (whether or not the DropLList was added to Col L) as entering a formula using a Column header (e.g. =Sum(Table1[Income]) picks up all the values from row 2 to the last row of the new data.

    I got round it in the end by adding a Change Event macro that duplicates L2 down to the last row, so I'll mark this as Solved and put the fact that the DropLists weren't created in June as Sunspot activity, or the Bermuda triangle . .

    Ochimus

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 07-16-2016, 10:53 PM
  2. [SOLVED] Automatically Adding Rows
    By jatolo in forum Excel General
    Replies: 4
    Last Post: 04-06-2014, 02:09 PM
  3. Can't automatically add checkboxes when adding rows
    By bcurry3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-04-2011, 03:31 PM
  4. Adding rows Automatically in Excell
    By TranceCo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2009, 02:27 PM
  5. adding rows automatically
    By saintr in forum Excel General
    Replies: 2
    Last Post: 05-12-2007, 09:30 PM
  6. adding images to excel table automatically
    By Grafula in forum Excel General
    Replies: 1
    Last Post: 03-14-2006, 04:33 AM
  7. [SOLVED] Automatically adding new rows with formula
    By Brian in forum Excel General
    Replies: 2
    Last Post: 01-16-2005, 11:06 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