Drop-down lists

[cantste3]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create a drop-down list using data on another worksheet. I am trying to write the source so that it references the other worksheet and then the column to pull the list from. I know this can be done on a PC. I am using the data validation and all but it still will not create the list. do I have to write every name in the source box? Thank you for your help.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create a drop-down list using data on another worksheet. I am
trying to write the source so that it references the other worksheet and then
the column to pull the list from. I know this can be done on a PC. I am using
the data validation and all but it still will not create the list. do I have
to write every name in the source box? Thank you for your help.

You should be able to use a defined name that refers to the list in the
other worksheet. Then use the name for the data validation list.

 

[graydavidl]

You should be able to use a defined name that refers to the list in the
other worksheet. Then use the name for thedatavalidationlist.

When I try to refer to data in another worksheet (in the same
workbook) it gives me an error message saying Data Validation cannot
refer to data in another worksheet of workbook. This seems to be a
major difference between the Mac and the PC where this works just
fine. I tried creating a name which didn't do anything and when I
explicitly pasted in the data range in the other worksheet it gave me
the error message

 

[JE McGimpsey]

When I try to refer to data in another worksheet (in the same
workbook) it gives me an error message saying Data Validation cannot
refer to data in another worksheet of workbook. This seems to be a
major difference between the Mac and the PC where this works just
fine. I tried creating a name which didn't do anything and when I
explicitly pasted in the data range in the other worksheet it gave me
the error message

What do you mean by "I tried creating a name which didn't do anything"?
Did you also try to use the named range?

Not doing *anything* seems unlikely - I would have thought you'd get an
error (if the named range wasn't defined correctly) or get an incoorect
list (if you didn't make the correct entry in the Data Validation
dialog). Having *nothing* happen doesn't make any sense.

Did you enter

=MyRangeName

in the list field in the Data Validation dialog?

Does the name show the correct range (using the sheet name and absolute
references) in the Insert/Name/Define dialog?

 

[graydavidl]

What do you mean by "I tried creating a name which didn't do anything"?
Did you also try to use the named range?

Not doing *anything* seems unlikely - I would have thought you'd get an
error (if the named range wasn't defined correctly) or get an incoorect
list (if you didn't make the correct entry in theDataValidation
dialog). Having *nothing* happen doesn't make any sense.

Did you enter

   =MyRangeName

in the list field in theDataValidationdialog?

Does the name show the correct range (using the sheet name and absolute
references) in the Insert/Name/Define dialog?

Yes, I created a named range and when I use that as the validation it
just drops down that name not the list of values in the range with
that name.

 

[JE McGimpsey]

Yes, I created a named range and when I use that as the validation it
just drops down that name not the list of values in the range with
that name.

The only way I can make that happen (assuming you defined your named
range correctly) is to fail to start with "=" in entering "=MyRangeName"
in the Data Validation dialog...