One column to multiple columns

[RevJeff]

Hi, I am trying to copy a column of cells from one sheet of my workbook to another sheet within the same workbook and turn them into mutiple columns.

Example:
Original text:

Bob
Mike
Erica
Karen
Kimberly

New Text:

Bob Mike Erica Karen Kimberly

Also, the amount of cells in the original sheet can vary. Is there a way of doing this with code?

Thanks!

[Steffen Thomsen]

Hi,

Try this

Please Login or Register  to view this content.

[RevJeff]

Thanks again!

I'll give it a shot.

[watersev]

hi, RevJeff, though it can be easily done by hands using Paste Special please check the code:

Please Login or Register  to view this content.

The data is supposed to start from A1 and down.