Hi! I would like to create an formula for in and out stock control system.
For example: Total Stock minus OUT quantity= Live stocks (10-5=5)
I am taking out stocks many times per day with different amount, so I need to have an total that is up to date. THANKS!!!
Hi, I need to have the TOTAL that is only changing when add/take away stocks. The input value is every time diferent.
I tried to play with macros a litle and it worked with stock OUT.
Now I only need to adjust the formula for IN stocks. Please help!!!
Find below the macro...
Private Sub Worksheet_Change(ByVal Target As Range)
Set r1 = Range("K2:K1000")
Set r2 = Range("L2:L1000")
If Intersect(r1, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Offset(0, 1).Value = Target.Offset(0, 1).Value - Target.Value
Application.EnableEvents = True
End Sub
= (a3) minus (b3) won't do it for you?
Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.
Example
The example may be easier to understand if you copy it to a blank
worksheet.
186 views
Usually answered in minutes!
×