Quick addition from short common list

Copper Contributor

For work I have to use a paper order form and input common items (10 max, prices, eg.104.38) for a total, I use the calculator on my phone, which means re typing the whole number every time. I have Excel on my phone. 

 

Any suggestions on setting up a quick addition sheet where I can do a single pick from a list to be added to the total?

 

Each maybe added multiple times. Also need the option for random prices.

 

Cheers

1 Reply

@Eddiesmate 

See if you can adapt the attached demo workbook. In the table on the left, press Tab in the last row with an item (above the total) to add a new row.