Hi,
i'm trying to get a neighbouring cell (b2) populated by the next value in a drop down lists selected in cell A1. For example the user selects orange from a drop down menu in cell A1, B2 is automatically populated by the next value in the list - blue.
Not sure if this possible but your help would be appreciated
Thanks
i'm trying to get a neighbouring cell (b2) populated by the next value in a drop down lists selected in cell A1. For example the user selects orange from a drop down menu in cell A1, B2 is automatically populated by the next value in the list - blue.
Not sure if this possible but your help would be appreciated
Thanks