Copy data from column A and B Sheet1 and paste into Sheet2

Hi,

I want to copy data from column A and B in first sheet and paste them to second sheet to, for example, column C and E. Point is that I want to paste them in one move, not to copy separately A to C(in another sheet), and B to E. Is that possible? I have tried to copy and paste, by selecting columns I want to paste in(C and E), but excel says that command cannot be used on multiple selections.

Thanks in advance,
Rabra.

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about a proper thread title and adjust accordingly...
• Changed for you this time, but please pick an appropriate title next time…Thanks.

No this is not possible. You can do it in VBA...