Hello,

I think this one is quite simple but i can`t figure it out. I have a user form that carries it`s history to a worksheet every time i press a button. In sheet 1 i have a list of all my inventory products.. Whenever a product goes out my inventory, i fill up this form and click a button. The information of the part and quantity goes to sheet 3 after i click this button.. What i want to do is automatically subtract the information gathered in sheet 3 to my main list in sheet 1.

For example, if i fill up my form where im taking 2 screwdrivers part#444 , this goes to sheet 3 for history. I also want to subtract 2 screwdrivers from my main list in sheet 1. hope i can get help.

thanks in advance.