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
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 19, 2016 | Computers & Internet
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.
Apr 30, 2011 | Computers & Internet
Sep 30, 2009 | Microsoft Excel for PC
Sep 16, 2009 | Microsoft Office Excel 2007
May 07, 2009 | Microsoft Excel 2007 Home and Student...
Feb 19, 2009 | Microsoft Computers & Internet
Jan 05, 2009 | Microsoft Computers & Internet
Dec 03, 2008 | Microsoft Office Professional 2007 Full...
Nov 27, 2008 | Computers & Internet
Jun 27, 2017 | VIA Computers & Internet
150 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: