Formula Help

[ssbns]

I need help to setup formula for the above so the Master Inventory form update automatically when I enter Items Qty. of Received/Sold/Returned and also When I put item code them item name should come automatically. Your help will be much appreciated. Thanks
Columns->	B	C	D	E	F	G
Lines	MASTER INVENTORY FORM
5	Item Code	Item Name	Qty
6	A1	Item 1
7	A2	Item 2
8	A3	Item 3
9	A4	Item 4
10	A5	Item 5
11	A6	Item 6
12	A7	Item 7
13	A8	Item 8
14	A9	Item 9
15	A10	Item 10
16	Items - (Received/Sold/Returned) Details
17
18	Item Code	Item Name	Date	QTY items Received	QTY Defective Items Returned	QTY Items Sold
19	A1	Item 1	Oct-01-2017	2
20	A2	Item 2	Oct-01-2017	4
21	A1	Item 1	Oct-15-2017		-1
22	A2	Item 2	Oct-15-2017			-2
23	A9	Item 9	Nov-12-2017		-2
24	A10	Item8	Nov-08-2017			-1
25	A1	Item 1	Oct-01-2017	2

<colgroup><col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="64" style="width: 48pt;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <tbody> </tbody>

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1030449-spreadsheet-formula-help.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.