Try this:

On Sheet1:

Headings in Row 1, Columns A to C

Desc | nxn | UPC

Example Data on rows 2, 3 and 4

Asian Plum | 2x2 | 83970100647
African Peach | 3x3 | 9060211556
American Grape| 1x1 | 62122542110

On Sheet 2:

Headings in Row 1, Columns A to D:

Seq Desc nxn UPC

Label in Cell F1:

No. of iterations:

Value in Cell G1:

6 ( = the number of copies of each row of sheet1 that you want to make
on sheet 2)



Formula in Cell A2:

=ROUNDUP(((CELL("row",Z2)-1)/$G$1),0)


Formula in Cell B2:

=OFFSET(Sheet1!$A$1,$A2,0)


Formula in Cell C2:

=OFFSET(Sheet1!$A$1,$A2,1)


Formula in Cell D2:

=OFFSET(Sheet1!$A$1,$A2,2)

Now copy formulas in row 2 down six times as many rows as you have on
Sheet 1


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=528568