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.
Bookmarks