Canberra
New member
- Joined
- Sep 18, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 1808
Hi,
Not sure which category this fits in but hopefully someone will be able to help us.
We're using excel to monitor our inventory. We all have pretty basic excel knowledge. We'd like to be able to track our stock levels with excel but currently our method is not particularly effective. We have a simple
'total (a1) = stock in (a2) - stock out (a3)' formula right now, but this require us to continuously add to the already present numbers (eg if we had previously received 50 items, and our next order was another 50, we would have to update a2 from 50 to 100) and this is getting confusing.
Is there a way to add an input cell where we could just type in how many we have received/used and have it added/subtracted from the total cell without requiring a constantly increasing count? Hopefully this makes sense and someone will be able to assist us,
Thanks
Not sure which category this fits in but hopefully someone will be able to help us.
We're using excel to monitor our inventory. We all have pretty basic excel knowledge. We'd like to be able to track our stock levels with excel but currently our method is not particularly effective. We have a simple
'total (a1) = stock in (a2) - stock out (a3)' formula right now, but this require us to continuously add to the already present numbers (eg if we had previously received 50 items, and our next order was another 50, we would have to update a2 from 50 to 100) and this is getting confusing.
Is there a way to add an input cell where we could just type in how many we have received/used and have it added/subtracted from the total cell without requiring a constantly increasing count? Hopefully this makes sense and someone will be able to assist us,
Thanks