easy one im sure, but i cant work it out! ![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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 quantity of orange in cell 2 is 7
is there a technical name for this?
many thanks!
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 quantity of orange in cell 2 is 7
is there a technical name for this?
many thanks!