forum1.png

Let's see the attached image above, Table2 show the item quantity that need to store into the basket in Table3.

Table1 will generate itself after we clicked the buttons.

forum2.png

Items will store into first basket until it full, then continue store into the next basket show in Table1 in image above.

A standard Basket contains 10 items, it allows user to store extra units by key-in in Table1 "Extra Unit" column, then the specific basket will store extra item.

VBA.png

When people key-in the "Extra-Unit", then click the button again or another "Extra Unit Button", then the table1 become as shown in picture3 above.

Is this possible to make it?