I'm having a terrible time getting something to work. I want two lists that
will automatically update when a new item is added that is not in the list.

I have a work book, representing a year. In the workbook are several sheets,
representing autos. In the workbook I have created one sheet that has two
lists in it, one for initials (Initial) and one for recording
damages(Descrepency). I have named the lists and set the target clumns in the
auto sheets to validate to the lists.
I read Debra Dalgleish's contextures on dynamic ranges but when I follow the
guidance there and insert the if= in defined name, the list names disappear
and the worksheets return an error that no list name can be found. I have
done everything my limited knowledge allows but have gotten nowhere with
this. I got some code from a fine gentleman for lists but it also has failed
to allow me to auto update, always returning some error.
I love this bulletin, but so far none of the recommended solutions out there
are working, I feel I am missing some simple step here. Help??