B
Bobby R.
Hi all, still in slight struggle - hope you can help.
First here is an example, then I will tell you the issue:
A B C D
E F
Inventory ID Product Name Max Stock Quantity Out On Hand
Ordered
1234 Spray Wax 50 20
30 (E1) 0
5678 3M Sand Paper 20 5
15
1234 Spray Wax 50 10
(E1-D3) 0
Okay here is the issue, I need to keep a running total (current on hand
stock) each time quantity goes out for a particular product as well as, when
specific products are ordered. In this example, Column E will give me a true
inventory amount for each product entered on the sheet based on the last "On
hand number" found in column E.
Any suggestions as to how I set this up on a worksheet. Yes, I know about
pivot tables but, that is not an option...they want a simple worksheet...lol!
Thanks.
First here is an example, then I will tell you the issue:
A B C D
E F
Inventory ID Product Name Max Stock Quantity Out On Hand
Ordered
1234 Spray Wax 50 20
30 (E1) 0
5678 3M Sand Paper 20 5
15
1234 Spray Wax 50 10
(E1-D3) 0
Okay here is the issue, I need to keep a running total (current on hand
stock) each time quantity goes out for a particular product as well as, when
specific products are ordered. In this example, Column E will give me a true
inventory amount for each product entered on the sheet based on the last "On
hand number" found in column E.
Any suggestions as to how I set this up on a worksheet. Yes, I know about
pivot tables but, that is not an option...they want a simple worksheet...lol!
Thanks.