Hello,
I am trying to see if there is a way to keep an automatic total of how much inventory I have on the floor based on date.
My first column has the total I started with at the beginning of the week, and then a column for each day with the quantity sold each day. I want a new column that shows how much is currently on the floor based on what day it is. I'm currently manually adding columns to the formula each day,but obviously this is not efficient.
For example,
I start with 100 cases of product at the beginning of the week. I plan to sell 20 cases on 8/1, 10 cases on 8/2, 10 cases on 8/3, 20 cases on 8/4, and 10 cases on 8/5. How can it auto-calculate so when I open the worksheet on 8/1, it shows I have 80 cases left, and then on 8/4 the same cell shows I have 40 cases left?
Thanks in advance!
Bookmarks