easy one im sure, but i cant work it out! :confused::confused::confused:
If cell A had a working dropdown menu, how does one make Cell B apply data based on that choice: i.e
if user chooses apple from cell one, the quantity of apple in cell 2 ALWAYS 6
if user chooses orange from cell one, the...