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
Combining one or more cells into 1 cell in excel Copy data from first column of many sheets to another one new sheet vba Copy data into sheet 2 Copy data to different sheet linked Copy files into c:windows with a .bat file Copy text from one cell into comments of another Copying data to active cell from a different cell in a work sheet Data copied from cells in one workbook cannot be pasted into another workbook Excel and conditional formatting of one cell based on value in a different cell Have excel transfer data from a different cell each day automatically How to copy numbers into different cells with excel How to write a macro for excel to sort multiple data into multiple columns Iphone copy data via usb Macro for copy paste data from one cell to the active cell in excel Macro to copy data into an excel file Summing different cells on different sheets Use one cell to refer to data in another cell Vba how to split text data in one cell into several cells