Field List-Data Validation

[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...

 

[Debra Dalgleish]

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]

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]

Go to Insert>Name>Define, and look at the definition of your
InterpretationColumn named range.
Is it an absolute reference?

 

[TXDalessandros]

Thank you!!!!

Go to Insert>Name>Define, and look at the definition of your
InterpretationColumn named range.
Is it an absolute reference?

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.