Adding and Subtracting quantity to an inventory list

Hello,

I am trying to create a list of inventory that I can add and subtract quantities to reflect our stock.

I did a search and I believe this thread is pretty much what I want:
http://www.excelforum.com/excel-prog...-function.html

The problem with that is that the document is in Spanish and I have forgotten everything but maybe a few numbers from the two years that I have taken x many years ago.

Background:
I know absolutely nothing about code!

What I would Like:
- to have either something on the top of the list or a userform to input the quantity that I am adding or subtracting.
- to be able to select the "bulb number" from a dropdown list, then type in a quantity that I am either adding or subtracting to the current quantity, select whether I am adding or subtracting, and then a "go" button.
- as a bonus, having a history list in another sheet would be great, with a date/time stamp of the change to inventory.

I would also like it to be simple enough for me to add new products to the list later on.

I also plan to be able to click on the "bulb number" and pull up a .pdf spec sheet of the bulb, but I should be able to do that...

I'm attaching what I have so far, which is not much:
IR BULB LIST.xlsx


Please Advise!
And Thank You!

Hi heJARRETconcept
Attached is a file with an approach that differs from your original approach. If you like it, use it else lose it. Let me know of issues.

Hi theJARRETconcept

You're welcome...glad to be of help.