Philippevr
New Member
- Joined
- Jul 14, 2014
- Messages
- 6
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.
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.