Question about Excel (SS8SATAS5128400R)
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
Posted on Sep 06, 2008
= (a3) minus (b3) won't do it for you?
Posted on Sep 05, 2008
Tips for a great answer:
Jul 14, 2009 | Network Storage Systems
Aug 19, 2008 | Excel (SS8SATAS5128400R)
Jul 12, 2008 | Excel (SS8SATAS5128400R)
Jun 16, 2008 | Excel (SS8SATAS5128400R)
May 22, 2008 | Excel (SS8SATAS5128400R)
Jan 25, 2008 | Network Storage Systems
149 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: