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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks