Hi all and thanks for such an AMAZING site! You've vicariously gotten me
out of several programming jams in the past, and I'm now a little
embarrassed to find myself between a code and a hard place.

I am writing (trying, anyway) VBA to do the following:

Once a macro is executed, excel looks at rows that have the following
information:

ColA ColB ColC ColD
ITEM# SLOT# DESCRIPTION # of Labels
5301 DF212 Black Beans 5
1624 CA172 Rice 2

I need to tell excel to (on a different sheet) create:

5301
Black Beans
DF212
5301
Black Beans
DF212
5301
Black Beans
DF212
5301
Black Beans
DF212
5301
Black Beans
DF212
1624
Rice
CA172
1624
Rice
CA172

...and so on. In other words, I need it to repeat the insert of the
Item#, Slot# and Description specified by what is entered for the #of
Labels.

Having been a great fan of this site for some time now, I know better
than to ask for a simple "Do it for me". Getting there is half the fun,
so they say. Any help or pointing in the right direction or hints or
clues or web site references would be incredibly appreciated.

Thanks again for such an awesome forum!

Jim C.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements