Copying data into different cells using macro

Abhi - Apr 21, 2009 at 06:30 AM
 raju - Jul 16, 2009 at 06:41 AM
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.


1 reply

Sub pl()

End Sub