software

i am having a problem where validation seems to disappear after i add data to
a list. i created a list of data and defined a name. i included extra rows
in my column list cause i know i need to add data regularly. i added data to
my list, and as soon as i go to the dropdown, it allows me to enter anything.
Also, if anyone can tell me how to make the data quot;autofillquot; - typing in
partially, and it fills in a value from the list.

thanks

I think you could benefit from visiting Debra Dalgleish's website.
Start he

www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;bruno1quot; wrote:

gt; i am having a problem where validation seems to disappear after i add data to
gt; a list. i created a list of data and defined a name. i included extra rows
gt; in my column list cause i know i need to add data regularly. i added data to
gt; my list, and as soon as i go to the dropdown, it allows me to enter anything.
gt; Also, if anyone can tell me how to make the data quot;autofillquot; - typing in
gt; partially, and it fills in a value from the list.
gt;
gt; thanks
gt;

This looks like it will help me. Thanks! Still baffeled by my initial issue
though. It seems that when the quot;Ignore blankquot; box is checked off it creates
problems. looks like another quirky excel thing.

Ron Coderre wrote:
gt;I think you could benefit from visiting Debra Dalgleish's website.
gt;Start he
gt;
gt;www.contextures.com/xlDataVal01.html
gt;
gt;Does that help?
gt;***********
gt;Regards,
gt;Ron
gt;
gt;XL2002, WinXP
gt;
gt;gt; i am having a problem where validation seems to disappear after i add data to
gt;gt; a list. i created a list of data and defined a name. i included extra rows
gt;[quoted text clipped - 4 lines]
gt;gt;
gt;gt; thanks