I tried to log into the group and see if this question has been addressed,
but the Discussions are temporarily unavailable.
So.. I'm sorry if this has been answered.
If this is as simple as you say..
Simply select the column data, and copy to the Clipboard (ctrl-C)
Go to the destination sheet (Sheet4), select a location, right-click
and select Paste Special.
On the panel, click the "transpose" checkbox.
this will paste the data in the columns as per our example.
If you wish to do this often, then record a macro and modify it to
fit your needs.
Let us know if you need additional assistance with this solution.
Paul
----- Original Message ----
> From: 0 1 <hhholme...@gmail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> Sent: Thu, December 2, 2010 4:01:37 PM
> Subject: $$Excel-Macros$$ Copy row values to columns
>
> In Sheet1, I have a dynamic range ("MyRange") that spans several rows
> in one column.
>
> I'd like to copy the values in each row into columns in Sheet4.
>
> For example, in Sheet1 MyRange has these values:
>
> A
> --
> 2
> 4
> 7
> 10
>
> In Sheet4, I'd like to return:
>
> A B C D
> -- -- -- --
> 2 4 7 10
>
> I suspect either a formula or macro would be the approach, just not
> sure of the best way.
>
> Thank you for any suggestions!
>
> --
>----------------------------------------------------------------------------------
>-
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
