sum if-match quantity

[Stacy Rueda]

Hi guys,

I have this excel file that I don't know how to start or what to use function or necessarily for macro.

I have input sheet, like below: When I input No. and quantity then it will sum to another sheet that match to the column that I inputted.

So, once I input No. 1-A, then quantity to other column will become 150, or if negative -50, then it will become 50.

INPUT DATA
No.	1-A
QTY.	50

<colgroup><col><col></colgroup><tbody>
</tbody>

No	QTY
1-A	100	Quantity will become 150
2-B	89
3-C	100
4-D	100
5-E	100
6-F	102
7-G	10
8-H	1092
9-I	1082
10-J	192
11-K	1982
12-L	1762

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

Hope you guys can help me. Thank you in advance.

 

[Stacy Rueda]

Guys, please help me..

 

[aqeelnokia99]

so what u want???

 

[Stacy Rueda]

Hi @aqeelnokia99, I want to create macro (but don't know how to start) that will compute automatically Quantity when I input quantity from other sheet. Once I input No. 1-A, then quantity to other column will become 150, or if negative -50, then it will become 50.

INPUT DATA SHEET
No. QTY.
1-A 50

RESULT:

No	QTY
1-A	100	Quantity will become 150
2-B	89
3-C	100

<tbody>
</tbody>

 

[aqeelnokia99]

if u put A1 in qty table its add 50 +??? or its become 150 for all and waht about 2-b and 3-c ? i can make a formula not macro

 

[Stacy Rueda]

Hi @aqeelnokia99, it will add depends on the quantity I input on "Input data sheet", and for 2-b, 3-c, 4-d rows, it will add also based from the quantity I entered.

 

[aqeelnokia99]

if its based on qty u want if u enter 100 in qty its become 150 if u eneter 50 its add 100 and become 150 if u add 30 its add 120 and become 150 ???

 

[Stacy Rueda]

no thanks.. I'm running out of explanation, sorry.