Copying data into different cells using macro

Closed
Report
-
 raju -
Hello,
I am trying to use macros to copy data from one cell into different cells in another sheet. My data is consisting of Organisation contact details. So i want to retain only organisation name in the cell and paste all other details separately into each different cell. For Example:
Boys & Girls Club of Greater Flint
P.O. Bosx 223
Flint, 48501

I want this data to appear as
Boys & Girls Club of Greater Flint P.O. Bosx 223 Flint MI 48501
with each appearing in different cell horizontally.
I tried by giving transpose but this will convert all the data into single row and i want each and every organisations to appear like this as i hav hundreds of details like this.

Pls let me kno how to do faster and simpler way using macros.

Abhi

1 reply

Sub pl()

Columns("E:E").Select
Selection.Copy
Columns("F:F").Select
ActiveSheet.Paste
End Sub
23