Copying Multiple Items

[Magnivy]

Greetings!

Is it somehow possible to copy multiple items on one worksheet, separately,
not as a group, and paste each item on another worksheet. For example, say
cells A1:C1 contain x,y,and z. Is it possible to copy the three items
separately, then go to Sheet2 and paste x in cell A5, y in cell B2, and z in
cell F10 without returning to Sheet1 and recopying each item.

I hope I explained it well. Please let me know if you have difficulty
understanding my question.

Any help on this would be greatly appreciated.

Magnivy

[pianoman]

sure...

just use the ranges to define variables for each...

xval = Range("A1")
yval = Range("B1")
zval = Range("C1")
Sheets("Sheet2").activate
Range("A5") = xval
Range("B2") = yval
Range("F10") = zval

Hope this helps

Gareth

Greetings!

Is it somehow possible to copy multiple items on one worksheet, separately,
not as a group, and paste each item on another worksheet. For example, say
cells A1:C1 contain x,y,and z. Is it possible to copy the three items
separately, then go to Sheet2 and paste x in cell A5, y in cell B2, and z in
cell F10 without returning to Sheet1 and recopying each item.

I hope I explained it well. Please let me know if you have difficulty
understanding my question.

Any help on this would be greatly appreciated.

Magnivy

[Magnivy]

Got it! Thank you very much Gareth!

"pianoman" wrote:

>
> sure...
>
> just use the ranges to define variables for each...
>
> xval = Range("A1")
> yval = Range("B1")
> zval = Range("C1")
> Sheets("Sheet2").activate
> Range("A5") = xval
> Range("B2") = yval
> Range("F10") = zval
>
> Hope this helps
>
> Gareth
>
> Magnivy Wrote:
> > Greetings!
> >
> > Is it somehow possible to copy multiple items on one worksheet,
> > separately,
> > not as a group, and paste each item on another worksheet. For example,
> > say
> > cells A1:C1 contain x,y,and z. Is it possible to copy the three items
> > separately, then go to Sheet2 and paste x in cell A5, y in cell B2, and
> > z in
> > cell F10 without returning to Sheet1 and recopying each item.
> >
> > I hope I explained it well. Please let me know if you have difficulty
> > understanding my question.
> >
> > Any help on this would be greatly appreciated.
> >
> > Magnivy
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=548562
>
>