Hi there, my project is trying to save time on my inventory file. Currently once a week i add my stock order (additions) to my inventory, i then deduct all the items we have used for that week (deductions) from the inventory. to do this currently i just use ctrl f to find the relevant sku in the inventory then manually add or deduct the number received / used and then move to the next line of either the additions or deductions depending on which i am doing. so for the first line of additions sku - 4931465388, we have received 37, i then look up this sku in inventory to find a qty of 68 i then add 37 to this making it 105. Later i would run through deductions and find that sku 4931465388 has been used 32 times so deduct this from 105 making it 73 this is then our current stock level.
as you can imagine this is extremely time consuming and i am sure there must be a formula that could be written to do this automatically.
our inventory is kept in google sheets but can obviousy be moved to excel etc for the purpose of this.
I have attached a copy an example file for all i have spoken about above, really hope someone can help.
19 freelancers are bidding on average £559 for this job
Hi, I have seen your project details for inventory project and completely understand the requirements. Kindly, award me this project so that we can discuss it briefly and start working.
Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!