dropdown manual

[et]

Hi,

I want to set some columns with dropdown manual using Validation -> list,
however the list must be in the same worksheet. Is there other way to set up
a downdown manual ? or is there any method to place the source list in other
worksheet as I don't want to confuse the user.

Please help.
Eling

 

[RagDyeR]

Can be done using named lists.
Check out Debra Dalgleish's site for exact instructions.

http://www.contextures.com/tiptech.html

Scroll down to "D", and check out the pages on DataValidation.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I want to set some columns with dropdown manual using Validation -> list,
however the list must be in the same worksheet. Is there other way to set up
a downdown manual ? or is there any method to place the source list in other
worksheet as I don't want to confuse the user.

Please help.
Eling

 

[Norman Jones]

Hi Eling,

Put the validation list on one worksheet and name it (as, say, "ListOne").

When applying the validation on another sheet, set the List source to:

=ListOne

To use another workbook, see the technique used by Debra Dalgleish at:

http://www.contextures.com/xlDataVal05.html

 

[Bob Phillips]

You can put the list on another worksheet, and name the range
(Insert>Name>Define Name...), and use that name, or reference it via
INDIRECT(INDIRECT("sheet_name!range_address") in the DV cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[et]

Thank you so much to all of you.