Field List-Data Validation

  • Thread starter Thread starter TXDalessandros
  • Start date Start date
T

TXDalessandros

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...
 
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
 
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?
 
Go to Insert>Name>Define, and look at the definition of your
InterpretationColumn named range.
Is it an absolute reference?
 
Thank you!!!!

Debra Dalgleish said:
Go to Insert>Name>Define, and look at the definition of your
InterpretationColumn named range.
Is it an absolute reference?
Click to expand...
 
Back
Top