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
Bookmarks