View Single Post
 
Old 01-06-2016, 10:22 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Regarding the data validation and the drop owns, the way I had it set up is it refers to a range specified in typical Excel RC format e.g. A2:A20. A more robust way is to refer to a named range. I have done that on the file attached (see a few posts down) and also included a list for Investigators. I will attach the file after I respond to everything here.

To add new list items, there are a few ways to do it:
* See that little doohickey on the bottom right of each list table? Grab it and drag it down.
* Select a cell or a group of cells, right click, and select Insert: Table Rows above. The number of rows inserted will be the number of cells selected.
* Once you have added your new items, sort the table.
* Don't leave blanks or they will appear in the list.
Reply With Quote