Simplify Multiple Transactions

If it were me, I'd have a Master Sheet and a Transactions Sheet.

The Transactions Sheet would simply have: Part # Date In/Out Quantity

The Master Sheet would have: Part # Opening In (Total) Out (Total) Stock

I'd use SUMIF or SUMIFS to keep total quantities Received and Issued which you could add and subtract from the Opening Stock Level to give a Current Stock Level. And I'd use an AutoFilter on the Transactions Sheet to look at the detailed transactions if I needed to see dates and quantities in and out.


Regards, TMS

You're welcome. Thanks for the rep.

Good luck with it. If it works for you, please mark the thread as solved.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Could you help with the formula I should be inputting into each cell?

I can't do anything with a picture of a worksheet

I can't do anything with a picture of a worksheet

i can ,easily

Thanks for your input Martin. Perhaps I should have been more specific? TMS