autogenerate rows based

[rainxking]

I am trying to put together a macro that will autogenerate rows and fill in information. I have to print shipping lables. The number of lables are based on how many boxes are being shipped. The number of boxes being shipped is based on how many units fit (this info never changes), but what is being shipped does. If this is confusing, I am sorry. I have attached a file. I would like excel make Table A look like Table B based on the information in Table C.

Say row 1 in Table A says there are 10 units of style ABC shipping. I can fit 5 units of style ABC in a box. I would like excel check table c, see ABC ships in sets of 5. Create a new table. Off the new table I print out my labels. Now there will be 2 rows each with Qty of 5 and carton 1 of 2 and carton 2 of 2.

My attached file is much easier to undersand.

Is this possible?

thanks for any help...