dropdown manual

  • Thread starter Thread starter et
  • Start date Start date
E

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
 
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
 
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)
 
Back
Top