Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation
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 "autofill" - typing in partially, and it fills in a value from the list. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation
I think you could benefit from visiting Debra Dalgleish's website.
Start he http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron XL2002, WinXP "bruno1" wrote: 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 "autofill" - typing in partially, and it fills in a value from the list. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation
This looks like it will help me. Thanks! Still baffeled by my initial issue
though. It seems that when the "Ignore blank" box is checked off it creates problems. looks like another quirky excel thing. Ron Coderre wrote: I think you could benefit from visiting Debra Dalgleish's website. Start he http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron XL2002, WinXP 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 [quoted text clipped - 4 lines] thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |