Maybe my last question..........
I have extended the data validation for 1000 rows for both jurisdiction and incident and I selected a range on the Data sheet that is much larger (more rows) so that new items can be entered.
I don't see blanks in the drop down for incident but I do for jurisdiction. Under the validation setting I have "Ignore Blank" checked.
Any clue why I'm seeing blanks in the drop down?
|