Paste copied multiple cell contents to same location on another sheet

**msmick** · 01-11-2012, 01:29 PM

Hi,

On sheet A, using the control key, I select and copy cells A10, A20 and A30.
I then go to sheet B select cell A10 and paste.
The result is that my copied cells are pasted in cells A10, A11 and A12 on sheet B.
How would I get them to paste in sheet B to the corresponding cells I copied them from on sheet A (Sheet B cells A10, A20 and A30)?

Thank You

**JieJenn** · 01-11-2012, 01:37 PM

lol.... to be honest, the only solution I can think of is using VBA. Here is the code that I came up with.

Please Login or Register  to view this content.

**msmick** · 01-11-2012, 01:49 PM

Wow,

Thanks JieJenn. Not what I was expecting, but I'll make it work.
I thought I was missing something with the paste special command but I guess not.
Funny thing is that I also use QuattroPro X5 frequently and the copy/paste behavior I am trying to accomplish here is native to that application.
Go figure.