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
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.