I didn't know how better to describe what I'm looking to do in the title, but hopfully this post makes more sense.
I have a "get data from database" running that pulls up quantities of stock. I have used this information to create a spreadsheet that will tell me where something in our warehouse should go once it has been received. It's actually pretty good. That's not really my issue. My issue comes from the fact that once we have shipped that equipment, we are moving it to a different locaiton. I need a way to make excel remember that there was once a qty in a cell after that qty resets back to zero. I had the thought (being from a programming backcround) of creating a new cell that will count up when that nubmer is changed from 0 to some qty, but then not reset when it's changed back to 0. (I.e. this cell would show Qty 1 if the previous qty was 1, 2 if it was 2, and so on) So that when I go back and look, I can see that there used to be x qty in that location before we shipped it.
I've searched best as I know how to, but I can't seem to find a function that would do this kind of thing. Any ideas or suggestions would be appreciated.
Bookmarks