How to create Add/Subtract VBA Code with Vlookup ?

[ToRaDoYa]

Good Day,,


I need VBA Code for Add button & Subtract Button, but with extra Features !! i Googled it but nothing helpful


the add button:
will take all the Products quantities from C9:C60, and search & find the items [the items in column D in Sales sheet] ,and Add the quantities [the Quantities in column G in Sales sheet]


the Subtract button:
will take all the Products quantities from C9:C60, and search & find the items [the items in column D in Sales sheet] ,and Subtract the quantities [the Quantities is in column G in Sales sheet]


Please Help, i will be waiting here for any answer

 

[Chihiro]

Upload sample workbook with expected result/output along with source data.

See link for something similar to your requirement.
http://chandoo.org/forum/threads/please-assist-for-vba-coding.29722/#post-177714

 

[ToRaDoYa]

what i want Briefly:

Add button: will add the quantities of C9:C23, to sales sheet column E

Subtract button: will Subtract the quantities of C9:C23, From sales sheet Column E
here is a sample file

 

[Chihiro]

Here you go. See attached.

Note: This assumed Column D in Sheet1 is unique list.

 

[ToRaDoYa]

First of all: thank you for your replay

you did it in the opposite way

i want the data to go from sheet1 to sales sheet so the stock column will increase or decrease

Not from Sales to sheet1, please help

 

[Chihiro]

I got bit confused from C9:C60 part. Any case, just reverse the range in code then

See attached.

 

[Marc L]

Cross posting with Excel Forum ‼
​

 

[ToRaDoYa]

MR Chihiro thank you very much for your help

I Tried the code it works Greet , i really appreciate your help, this code will make my life easier, tonight i will learn how to modify it, thanks again for your precious time.

Marc L, thanks for your warning next time, if i did cross posting,i will provide the link