ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying and pasting data muiltiple times (https://www.excelbanter.com/excel-discussion-misc-queries/80810-copying-pasting-data-muiltiple-times.html)

dalsx1

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=528569


dlw

Copying and pasting data muiltiple times
 
when you paste, highlight the entire range first, and it will past into those
cells

"dalsx1" wrote:


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=528569




All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com