Need help

[noelmus]

[FONT=&quot]In cell E19 I have a drop down list which has Pears, Apples and Bananas. In cell E20 I have the finish quantity and in cell E21 I have the start quantity. My questions are these:

[/FONT]
[FONT=&quot]1. Is it possible to use the same cells E20 and E21 for Pears, Apples and Bananas which have different quantities?[/FONT]
[FONT=&quot]2. If it is possible, will excel put the last Finish Quantity of each fruit to the Start Quantity for the next sale?[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks in advance[/FONT]

 

[njimack]

Take a look at https://contextures.com/xlDataVal02.html

 

[noelmus]

Hi,
My questions are not about drop down lists.