| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Field List-Data Validation
I have created a list of the following values
Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Field List-Data Validation
When you refer to the list in the data validation dialog box, use an
absolute reference or a named range. For example: =$B$2:$B$4 or =MyList TXDalessandros wrote: I have created a list of the following values Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Field List-Data Validation
I am doing that. I have named my list on another worksheet in this file
=InterpretationColumn It still only pulls the value I want one time. Once I use it I can not use it again on the next row? "Debra Dalgleish" wrote: When you refer to the list in the data validation dialog box, use an absolute reference or a named range. For example: =$B$2:$B$4 or =MyList TXDalessandros wrote: I have created a list of the following values Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Field List-Data Validation
Go to InsertNameDefine, and look at the definition of your
InterpretationColumn named range. Is it an absolute reference? TXDalessandros wrote: I am doing that. I have named my list on another worksheet in this file =InterpretationColumn It still only pulls the value I want one time. Once I use it I can not use it again on the next row? "Debra Dalgleish" wrote: When you refer to the list in the data validation dialog box, use an absolute reference or a named range. For example: =$B$2:$B$4 or =MyList TXDalessandros wrote: I have created a list of the following values Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Field List-Data Validation
Thank you!!!!
"Debra Dalgleish" wrote: Go to InsertNameDefine, and look at the definition of your InterpretationColumn named range. Is it an absolute reference? TXDalessandros wrote: I am doing that. I have named my list on another worksheet in this file =InterpretationColumn It still only pulls the value I want one time. Once I use it I can not use it again on the next row? "Debra Dalgleish" wrote: When you refer to the list in the data validation dialog box, use an absolute reference or a named range. For example: =$B$2:$B$4 or =MyList TXDalessandros wrote: I have created a list of the following values Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Field List-Data Validation
You're welcome! Thanks for letting me know that it helped.
TXDalessandros wrote: Thank you!!!! "Debra Dalgleish" wrote: Go to InsertNameDefine, and look at the definition of your InterpretationColumn named range. Is it an absolute reference? TXDalessandros wrote: I am doing that. I have named my list on another worksheet in this file =InterpretationColumn It still only pulls the value I want one time. Once I use it I can not use it again on the next row? "Debra Dalgleish" wrote: When you refer to the list in the data validation dialog box, use an absolute reference or a named range. For example: =$B$2:$B$4 or =MyList TXDalessandros wrote: I have created a list of the following values Yes-Omission Yes-Transposed No-Illegible I will be using those values over and over again. Why when I choose lets say Yes-Omission on row 2 can I not select it again in row 3 or 4 and so on... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| using data validation and inserting more than one item in a field | Excel Discussion (Misc queries) | |||
| How to save an Exel-sheet with over 10,000 list-/validation-field. | Excel Discussion (Misc queries) | |||
Hybrid Mode
