Copying and pasting data muiltiple times

D

dalsx1

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