Please in fact on A2:A12 there is a drop down menu , with name of fruits let say that in A2 I have option to pick on of those 10 fruit names:
For exemple
If I pick Apple on A2 then In C1 I must have Apple displayed
If I pick Orange on A3 the on D1 shows Orange:
If I pick Apple again on A4 Then in E1 shows APPLE
If I pick Bananas in A10 Then In F1 shows Banana
if I pick Grapes in A11 then in G1 shows Grapes ,
But if I unselect Grape in A11 then G1 should empty
an the I pick Melon in A11 and it shows in G1
Thank you waiting for the help
If
Bookmarks