+ Reply to Thread
Results 1 to 3 of 3

Data Validation Does Not Extend In Table After Addition of Row

  1. #1
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Data Validation Does Not Extend In Table After Addition of Row

    I have a workbook (see attached) with a sheet labelled "Tissue." I expand the table be selecting just underneath the bottom of the table in column A. I have data validations in several columns that expand with a row is added—save one column: column H (known as Inoculation Tech). When the cell is highlighted, the drop-down arrow doesn’t appear. I can still choose from a drop-down if I right click the cell and select "pick from drop-down list." The data validation for column H should be the list option in data validation and the source should be =NameDynamic.
    Help! If you are able to fix it or know how, elucidate how you did it, because I have exhausted all known possibilities.
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Data Validation Does Not Extend In Table After Addition of Row

    it works now
    just cleared conditions in the column and then made validation again
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Re: Data Validation Does Not Extend In Table After Addition of Row

    Please explain to me what you did & how you did it. I have the same file at work I need to update. I cannot just take this file and move it to work. The original file has already been updated with other data.

+ 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. Automatically extend line graph when adding more data into a table.
    By mavaspa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-01-2016, 02:25 AM
  2. [SOLVED] Extend or reduce table format according to data input
    By c887173 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2014, 12:54 PM
  3. Extend range of table automatically to fit data
    By b624333 in forum Excel General
    Replies: 1
    Last Post: 07-14-2014, 01:00 PM
  4. [SOLVED] Data validation - 3 cell addition should equal value in one cell
    By aalim95 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-15-2013, 10:24 PM
  5. How to extend Range.AutoFill Destination down an addition 3 rows?
    By BBoydAnchor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2011, 10:51 AM
  6. Extend Data Validation to Multiple Sheets
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2010, 07:13 PM
  7. Can I extend the drop down from a validation list?
    By rhyan66 in forum Excel General
    Replies: 1
    Last Post: 04-09-2007, 01:53 PM

Tags for this Thread

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