How to create Add/Subtract VBA Code with Vlookup ?

[toradoya]

Good Day,,


I need VBA Codes 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

[Arkadi]

Can you attach a sample workbook?

[toradoya]

Can you attach a sample workbook?

here is the sample,

what i want Briefly:

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


Subtract button will Subtract the quantities of C9:C23, from sales sheet

[Arkadi]

See if these work for you?

Please Login or Register  to view this content.

[Marc L]

Cross posting with Chandoo.org !

[toradoya]

See if these work for you?

Please Login or Register  to view this content.

It Worked !!! Smoothly , You Are life saver

Its very Easy to understand the code because of your Clear instruction inside the Code

You have Made My Day

MR Arkadi, Thank You So Much for your Help, and for your precious time

Cross posting with Chandoo.org !

Good Day Mr Marc L, Yes i Posted my question in Chandoo website, it's better to ask different people to get the best answer.

is it against the rules !!, if yes then my i apologize for that

[Arkadi]

toradoya,

First, you are welcome, glad I could help. I like to put comments explaining what the code does since most people are interested in learning, not just getting the code written for them.
Second, cross posting is not exactly against the rules, but it also means people might be wasting their time answering something that someone else has already solved. For that reason, we always ask that when you do cross post, that you put a link in your post to the other page you have asked the question in.

Please take a moment to read the forum rules, it will help you, and it will help us if you are familiar with them. Rule #8 is the one that applies to cross posting.

And please, if you are satisfied with the solution, remember to mark the thread as solved? Thanks in advance!

[toradoya]

toradoya,

First, you are welcome, glad I could help. I like to put comments explaining what the code does since most people are interested in learning, not just getting the code written for them.

Thanks Again for your Explanation in side the code i really learned how to modify it, you made coding looks simple

toradoya,

Second, cross posting is not exactly against the rules, but it also means people might be wasting their time answering something that someone else has already solved. For that reason, we always ask that when you do cross post, that you put a link in your post to the other page you have asked the question in.

Please take a moment to read the forum rules, it will help you, and it will help us if you are familiar with them. Rule #8 is the one that applies to cross posting.

And please, if you are satisfied with the solution, remember to mark the thread as solved? Thanks in advance!

Next Time I will Provide a link for the other page in case of cross posting, also thanks for the forum-rules link, i will read it.


Thanks a lot
Regards,
ToRaDoYa