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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!