I need this to be automated (i.e., with a formula or macro), and it
needs to handle the fact that the source data is part of a dynamic
range and will often change. But I used your transpose idea and came
up with this macro, which does the job:
Sheets("Sheet1").Range("MyRange").Copy
Sheets("Sheet4"
need additional assistance with this solution.
Paul
- Original Message
> From: 0 1
> To: MS EXCEL AND VBA MACROS
> 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 s
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 ei
