Copying data into different cells using macro [Closed]

Question

Copying data into different cells using macro [Closed]

Report

Abhi - Apr 21, 2009 at 06:30 AM
raju - Jul 16, 2009 at 06:41 AM

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

Copying data into different cells using macro
VBA - A macro to remove part of the data contained in cells - How-To - Excel
Macro for filling data from specific cell to another ✓ - Forum - Excel
Macro to insert data to changing cells ✓ - Forum - Excel
Macro for copying data from different sheets ✓ - Forum - Excel
How to copy data from one cell to another in excel automatically - How-To - Excel

1 reply

Ask a question

raju · Accepted Answer · 2009-07-16T06:41:16-0400

Answer 1 / 1

raju
Jul 16, 2009 at 06:41 AM

Sub pl()

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

Copying data into different cells using macro [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!