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

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

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

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

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

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