Appendix Thread. ( Codes for other Threads, etc.) Event Coding Drpdown Data validation

[DocAElstein]

Worked example for this Thread
https://excelfox.com/forum/showthrea...sult-is-change

Before: as supplied by OP

_____ Workbook: help0824.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K
15	ITEM	DESCRIPTION					QTY	UNIT	UNIT PRICE	TOTAL AMOUNT	REMARKS
16	1						3		30	90
17
18	2						20		1.5	30
19	3						4		55	220
20
21	4						1		250	250
22
23
24
25
26
27
28
29
30
31
32
33
34
35		Total					7			310.00

Worksheet: Sheet2

After
The macro is an events coding macro so it starts automatically,
....For example, I do the given example... ....'Example:
'Suppose the user fills in 3 in Cell G20, user fills in 15.25 in Cell I20 ,
'the serial number of Cell A20 serial number will automatic become 4,
' and the original 4 of cell A21 will automatically become 5
'
'At this time, G35 original is 7 , will automatically calculates 10,
' J20 automatically calculates 45.75
'At this time, J35 original is 310 , will automatically calculates 355.75

_____ Workbook: help0824.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K
15	ITEM	DESCRIPTION					QTY	UNIT	UNIT PRICE	TOTAL AMOUNT	REMARKS
16	1						3		30	90
17
18	2						20		1.5	30
19	3						4		55	220
20	4						3		15.25	45.75
21	5						1		250	250
22
23
24
25
26
27
28
29
30
31
32
33
34
35		Total					10			355.75

Worksheet: Sheet2