autogenerate rows based

R

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting multiple headings on a document 1
Footer On Last Page Only Not Working 1
Insert rows by group and copy value 2
Workbook code to Module Code 4
Making Box Labels on UPS Thermal Using Excel. 1
For all rows, if cell has "X", get number from range? 6
How to create a dynamic table based on a set of other nested attributes 0
Inventory Loop 2

Top