Pull Down Menu

[wpm7113]

Hello,

I like to ask for solution. Let's say that I have row of data in Column A and I like to use the pull down list to show in column C, however, once I have selected the data from column A into Column C row, I don't want to have the pull down list to display that data again.

here is the example:

Column A | Column B | Column C
1 Apple ->Pull down Menu will show (all item in Column A) and I select "Orange"
2 Banana -> in this pull down menu, I want the Orange to be disappear on the list as it is already show in Column C Row 1
3 Orange
4 Mango
5 Melon


Please advice and appreciate your help.

Cheers
Raymond

[Pete_UK]

Debra Dalgleish shows in a very clear manner how you can do this, on her website here:

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

Hope this helps.

Pete

[wpm7113]

Hi Pete,

Thanks and this is exactly what I want. but can I ask you one more question? it is possible to key in the data directly to the field without selecting the pulldown? the data is a valid data.

Cheers
Raymond

[Pete_UK]

Yes, you should be able to type a valid value directly into the field, without using the drop-down.

Pete

[wpm7113]

Hi Pete, I still can't.. Please see the attached files.

[wpm7113]

Anyone can advice?