Hi All,
Can anyone point out where i am going wrong:
I have a Stock Table that when new Stock is received it is moved to working Table: Example:
1. Stock is moved to this working table when booked in on the main Table. A2:An (Oldest Stock first) B2 is the Available stock from A2.
2. When stock is sold or deleted due to expiry Date in main Table it appears in the working Table in C2
I have a Macro that Takes the Book Out Amount from the Available amount, When the available amount is insufficiant to meet the Book Out Amount the it books out the Available amount to 0 and the rest from B3 which is the next oldest.
My problem is that it only does this for B2 -> B3 and then goes to minus amount in B3 and not into B4.
How can i ammend this macro so once a Quantity is 0 it moves down through the Available Quantities each in turn?
The Macro Code is as Follows:
Any Help would be greatly appreciated.
Regards
JRidge
Bookmarks