macro to create rows of data based on divided quantities

I need a code that will take the amount I have on order for a certain day, divide it by the amount in a container and create a line item for each of the divisable amounts plus the remainder. For example: I have 250 (cell F21) on order for 11/28 (cell B21) and 100 qty per container (cell P3). The results should be

Column P Column Q
11/28 100
11/28 100
11/28 50

Thank you.

Put this into a regular code module (Insert > Module):

Please Login or Register  to view this content.

Hello MSapprentice,

Here is another solution with additional flexibility. This macro will allow you to have the container amount list on another sheet. The macro also sizes the table dynamically so you won't have to modify the macro when adding or deleting rows. The attached workbook has the macro added.

Please Login or Register  to view this content.