|
Re: Macro for single to multiple cols. Help!
You don't need a macro, necessarily. Try Vertical to Horizontal Addresses
at:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"dfkelly42" <dfkelly42.1rgp6h_1120172755.632@excelforum-nospam.com> wrote in
message news:dfkelly42.1rgp6h_1120172755.632@excelforum-nospam.com...
>
> Single col excell spreadsheet
> example
> (rows) all data in col A
> 1) john doe
> 2) nice guy
> 3) 1010 space street
> 4) Nasa Florida
> 5) (data separated by 1 row here)
> 6) Jane Smith
> 7) Nice girl
> 8) 1011 Space st
> 9) Nasa Florida
> 10)
> etc...........
>
> Wishing to populate each row 1-4 into A-D cols. repeating multiple
> times into just the 4 cols A-D without spaces between the rows.
> example.....
>
> (col A) (B) (C) (D)
> 1)john doe/nice guy/1010 space street/Nasa Florida
> 2)Jane Smith/Nice girl/1011 Space st/Nasa Florida
> 3) etc.....
>
>
> AND!!!
>
> same macro but populating 5 cols from 5 rows, instead of 4.
>
> Much appreciated for the help...
>
> dfkelly42
>
>
> --
> dfkelly42
> ------------------------------------------------------------------------
> dfkelly42's Profile:
http://www.excelforum.com/member.php...o&userid=12094
> View this thread: http://www.excelforum.com/showthread...hreadid=383737
>
|