PDA

View Full Version : data validation



mtsf26
01-15-2012, 11:01 PM
I just curious if i use data validation in LIST style in one column.then can i add more data in that column??is there any other way to use the list and also type in one column at the same time?

mikerickson
01-16-2012, 12:25 AM
If you either uncheck the Show Error Message check box or set the Error Style to Information or Warning, the user can type an entry that is not on the list into a cell.

If you want to expand the source list, a dynamic name could be used. Something like
Name: sourceRange RefersTo: =Sheet1!$A$1:INDEX(Sheet1!$A:$A, COUNTA(Sheet1!$A:$A), 1)