Hi Fellside64,
I have read your short requirement. Normally when we use Excel to manage stock, we use excel spreadsheet in the database style. This means we will keep all the feeding data will be archive to the bottom of the spreadsheet everytime, but have some flag to indicate the activity (reveive, sales). Then the Ending stock = BF + Rcv - Sell (BF - bring forward qty / Rcv = Receiving qty / Sell = sold qty), then not only the transaction type, we still keep the time log so that we have evident of time for trace & track reference.
That is the database part, the in another sheet will be Inventory monitor, here we will put some code to list the product item at the same time calculate the ending inventory.
So now about the van (delivery)...this concern to the customer purchase order, we will log this activity at the Po no. (purchase order number not at Item level), but of course we will have the record of all items in each PO. Then we keep tracking from this worksheet.
So now we can trace & track and do analysis...(see sales trend, Rcv trend, Inventory Days on hand..etc) on our company actitity.
Feel free for further discussion, if you are interested.
let me introduce myself a little, I am an excel developer, expert in Excel both excel standard and Vba coding, more than 10 years. You can see more of my profile and expertise in my project feedback in http://www.freelancer.com/users/feedback_2698784.html
Kind regards,
Pichart Y.