software

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 2x283970100647 ( these are individual cells)

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

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: www.excelforum.com/member.php...oamp;userid=33041
View this thread: www.excelforum.com/showthread...hreadid=528569when you paste, highlight the entire range first, and it will past into those
cells

quot;dalsx1quot; wrote:

gt;
gt; I need to extract data from cells on sheet that I have to another sheet,
gt; however, I need to paste it on the second sheet numerous times (See
gt; example below).
gt;
gt;
gt; From Sheet #1:
gt; Asian Plum 2x283970100647 ( these are individual cells)
gt;
gt; On sheet #2 I need to see this:
gt; Asian Plum 2x283970100647
gt; Asian Plum 2x283970100647
gt; Asian Plum 2x283970100647
gt; Asian Plum 2x283970100647
gt; Asian Plum 2x283970100647
gt; Asian Plum 2x283970100647
gt;
gt; I know that I can copy and paste the data but could be very time
gt; comsuming if I have numerous UPC's to print.
gt;
gt;
gt; --
gt; dalsx1
gt; ------------------------------------------------------------------------
gt; dalsx1's Profile: www.excelforum.com/member.php...oamp;userid=33041
gt; View this thread: www.excelforum.com/showthread...hreadid=528569
gt;
gt;