Copy paste from various cells to one row on different worksheet

**helpappreciated** · 12-26-2012, 12:16 AM

Hello,

is it possible to copy from say (A1,A8,A9,A17) to (A1,A2,A3,A4) on another worksheet? Is their a formula for this?

**Steve N.** · 12-26-2012, 12:21 AM

Yes. Select A1, hold down the control key and click in each of the other cells you want to copy - click Copy. Go to the new area and paste.

**:) Sixthsense :)** · 12-26-2012, 12:24 AM

In the another sheet A1 cell press = and click the first sheet a1 cell. Like this do it for remaining cells.

**helpappreciated** · 12-26-2012, 02:32 AM

"sixth" ..thank you!!, worked perfect!
and thank you as well Steve for trying

Re: Copy paste from various cells to one row on different worksheet