jonespandrew
New Member
- Joined
- Oct 8, 2015
- Messages
- 49
Hi There
I am trying to create a spreadsheet that tracks the removal fo stock from stores to a site and then back again.
Example please see attached.
What i am trying to do is track how much stock goes out, what is left in stock then when the stock was returned to stores and how much was returned to stores, what is outstanding etc, so i can keep track of who is taking what out of the building. any ideas or suggestions this is what i have so far.
for example if the qty returned is equal to what was taken out then the stock available needs to return to 52, as 52 is what we will hold if nothing is taken out.
I am trying to create a spreadsheet that tracks the removal fo stock from stores to a site and then back again.
Example please see attached.
What i am trying to do is track how much stock goes out, what is left in stock then when the stock was returned to stores and how much was returned to stores, what is outstanding etc, so i can keep track of who is taking what out of the building. any ideas or suggestions this is what i have so far.
for example if the qty returned is equal to what was taken out then the stock available needs to return to 52, as 52 is what we will hold if nothing is taken out.