Daily inventory follow up - opening stock = to closing stock previous day if....

[Philippevr]

Hi,

I have a simple worksheet with daily stock entry and withdrawal for different items (based on a validation list).

Column A = product description (items from the validation data list)
Column B = Opening stock
Column C = Withdrawal stock
Column D = Closing stock

I want to find automatically the opening stock based on the previous closing stock after I have selected the item.

Any suggestions please?

Phil.

 

[Peter_SSs]

Peter, I am really fascinated how Excel experts like you find these formulas. How do you get there.

For me, it was mostly hanging around this forum a lot, looking at & trying to understand posts from the gurus, & lots of trial & error.