Need VBA code to split quantities based on availability in another table

[adelkam]

I have a small table where I record quantities ordered for few items. I also have another table that shows availability over the next few weeks.
I need to check the availability of the entered quantities on the entered date in the second table. If the requested quantity exceed the available for that week, then check if the remainder would be available in the following week and so on until the whole quantity is met. I would like to split the initially requested quantity over number of weeks based on findings of the availability.

I appreciate if somebody can help on this .. example attached ..thanks

[AlphaFrog]

Please Login or Register  to view this content.

[adelkam]

Thanks AlphaFrog!! This is fantastic.. it works perfect !!