I am trying to use dependent droplists to input addresses on invoices. I
need to create a series of five dependent lists. There are a total of 68
items in the initial list, with 1-18 items in the second (for each of the
68), and 1-2 items in the third, and only one option in the last two. I have
tried using the directions found here
(http://www.contextures.com/xlDataVal13.html), but I cannot get it to work
with my data. The initial list works perfectly, but the second list is
empty. I also need the cells to progress down a column, instead of across a
row.