Excel Visual basic Copy cells

[dawid294]

Hello i am new in Visual Basic . I need help with macro. I have data in one column. there are a lot on rows.
Every second row should be in the second column .Please can you help me . Thank you

Jan
2030
Peter
-545
Zuzana
-287

It would like to look like this.
Jan 2030
Peter -545
Zuzana -287

[KOKOSEK]

Try like this:

Please Login or Register  to view this content.

Of course you have to set proper ranges, result columns, etc.

[Sintek]

Another option...

Please Login or Register  to view this content.