Drag and Drop Down list!?

[Neo1]

Hello I want to create a drag and drop down list but how can I create
one by getting the list of data from another worksheet in the same
file?


Thanks
From John

 

[Debra Dalgleish]

If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions here:

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

 

[L. Howard Kittle]

Hi John,

You can name the list on the other sheet and then in the Source box enter
=NameOfList.

HTH
Regards,
Howard

 

[Neo1]

Thanks, but now the problem lies in doing the IF statement, such that
when i try to say IF the cell with the drag and drop list is "this name
(stated in other worksheet" then put 5 etc...Do i need to type in the
whole name? What i did is just clicked on a cell of data list of the
other worksheet so that for example

=IF(B6 = Sheet2!C6,"5"........ This way it doesnt seem to work i
need to type in the full name instead of putting the cell number.....
isnt there another way instead of putting the entire name?

Thanks
From John

 

[L. Howard Kittle]

Hi John,

On the sheet that has the list, go there and name the list. I will call it
"MyList".
Back on the sheet with the drop down, under Data > Valadation > Sittings >
Allow > List In > Source > =MyList > OK.

Should get you there.

No IF statement needed.

HTH
Regards,
Howard

 

[L. Howard Kittle]

Hmmmm, I said > List in >

Not! Do!! >List >

Sorry,
HTH
Regards,
Howrd