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...


+-------------------------------------------------------------------+
|Filename: table sample.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4459 |
+-------------------------------------------------------------------+

--
rainxking
------------------------------------------------------------------------
rainxking's Profile: http://www.excelforum.com/member.php...fo&userid=9431
View this thread: http://www.excelforum.com/showthread...hreadid=522471