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