Copying and pasting data muiltiple times
 

I need to extract data from cells on sheet that I have to another sheet,
however, I need to paste it on the second sheet numerous times (See
example below).


From Sheet #1:
Asian Plum 2x2 83970100647 ( these are individual cells)

On sheet #2 I need to see this:
Asian Plum 2x2 83970100647
Asian Plum 2x2 83970100647
Asian Plum 2x2 83970100647
Asian Plum 2x2 83970100647
Asian Plum 2x2 83970100647
Asian Plum 2x2 83970100647

I know that I can copy and paste the data but could be very time
comsuming if I have numerous UPC's to print.


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

Copying and pasting data muiltiple times
 

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