Sheet 1:
The first table shows a list of orders (Africa 58, USA 59…) and the quantity to produce of each item (item 1, item 2, item 3…).
In another sheet, I want in Cell B2 to show me a list of all items to produce in order USA 59 as per cell A2 (not to include item 1 because the quantity is 0). However, after selecting an item in the list, if I choose in cell A3 the order USA 59 and I click on cell B3, I need a list of all the REMAINING items to produce in order USA 59 (not to include the item selected in B2 because it is already taken).
Furthermore, in cell C2, C3, C4, I want the quantity to be shown automatically depending on the order number and the item selected.
Thank you for your help, I really appreciate it.
| A | B | C | D | |
| 1 | Africa 58 | USA 59 | Brazil 60 | |
| 2 | Quantity in pieces | |||
| 3 | item 1 | 100 | 0 | 0 |
| 4 | item 2 | 90 | 100 | 0 |
| 5 | item 3 | 80 | 20 | 60 |
| 6 | item 4 | 70 | 40 | 300 |
Sheet 2: |
| A | B | C | |
| 1 | Order Number | Items | Quantity |
| 2 | USA 59 | ||
| 3 | USA 59 | ||
| 4 | |||
| 5 |
The first table shows a list of orders (Africa 58, USA 59…) and the quantity to produce of each item (item 1, item 2, item 3…).
In another sheet, I want in Cell B2 to show me a list of all items to produce in order USA 59 as per cell A2 (not to include item 1 because the quantity is 0). However, after selecting an item in the list, if I choose in cell A3 the order USA 59 and I click on cell B3, I need a list of all the REMAINING items to produce in order USA 59 (not to include the item selected in B2 because it is already taken).
Furthermore, in cell C2, C3, C4, I want the quantity to be shown automatically depending on the order number and the item selected.
Thank you for your help, I really appreciate it.
