Macro to add Quantity or Subtract Quantity On Stock

[Xefi]

Hello, I am looking for a solution to my VBA. I am looking to add a reference in cells G7 or H7, this allows you to add or remove a quantity and
update our stock


My Excel

Classeur3
	B	C	D	E	F	G	H
4
5	Reference	tag	Quantity			Reference
6	123	clock 1	14			Add +1 quantity	Reduce -1 quantity
7	124	watch 2	5
8	125	applewatch	7
9	126	samsung 22	4
10	127	windows 33	3
11	128	apple	15
Feuil1

thank you very much for all help .
Do you have any ideas for success?

 

[lrobbo314]

How about this?

Sub AddSubtract()
Dim RF As Range:    Set RF = Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).Find(Range("F2").Value2, , xlValues, xlWhole)
Dim Trg As Range:   Set Trg = RF.Offset(, 2)
Dim Add As Range:   Set Add = Range("F4")
Dim Subt As Range:  Set Subt = Range("G4")

Trg.Value = Trg.Value + (Add.Value - Subt.Value)

End Sub

 

[Xefi]

I don't understand the code , I have to adapt it and continue?

 

[Xefi]

by adding a reference in cell G7 or H7 this takes the value of the quantity in column D to add or subtract it. Then it erases the G7 and H7 cells by updating the stock