I need help to setup formula for the following spreadsheet so the Master Inventory form update automatically when I enter Items QTY of Received/Sold/Returned items and also When I ENTER item code theN item name should come automatilly. Your help will be much appreciated. Thanks -------------------------------------------------------------------------------------------------------------- MASTER INVENTORY FORM | ||||||
Item Code | Item Name | Qty | Item Code | Item Name | Qty | |
A1 | Item 1 | 5 | A17 | Item 17 | ||
A2 | Item 2 | A18 | Item 18 | |||
A3 | Item 3 | A19 | Item 19 | |||
A4 | Item 4 | A20 | Item 20 | |||
A5 | Item 5 | A21 | Item 21 | |||
A6 | Item 6 | A22 | Item 22 | |||
A7 | Item 7 | A23 | Item 23 | |||
A8 | Item 8 | A24 | Item 24 | |||
A9 | Item 9 | A25 | Item 25 | |||
A10 | Item 10 | A26 | Item 26 | |||
A11 | Item 11 | A27 | Item 27 | |||
A12 | Item 12 | A28 | Item 28 | |||
A13 | Item 13 | A29 | Item 29 | |||
A14 | Item 14 | A30 | Item 30 | |||
A15 | Item 15 | A31 | Item 31 | |||
A16 | Item 16 | A32 | Item 32 | |||
Items Received/Sold/Returned Details | ||||||
Item Code | Item Name | Date | QTY item Received | QTY Defective Item Returned | QTY Item Sold | |
A1 | Item 1 | Oct-01-2017 | 2 | |||
A2 | Item 2 | Oct-01-2017 | 4 | |||
A18 | Item 18 | Nov-01-2017 | 4 | |||
A19 | Item 19 | Nov-01-2017 | 6 | |||
A1 | Item 1 | Oct-15-2017 | 1 | |||
A2 | Item 2 | Oct-15-2017 | 2 | |||
A19 | Item 19 | Nov-12-2017 | 1 | |||
A18 | Item 18 | Nov-14-2017 | 1 | |||
A1 | Item 1 | Oct-01-2017 | 2 | |||
<tbody>
</tbody>