How can I copy a formula into a column but extend it by row
You're welcome......I'm glad I could help
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"lhouck12" wrote in message
...
Yes
Thank You
"Ron Coderre" wrote:
Perhaps something like this:
With:
B1: Alpha
C1: Bravo
D1: Charlie
E1: Echo
A2: =INDEX($B$1:$E$1,ROWS($1:1))
Copy that formula down as far as you need.
In the above example, these values are returned:
A2: Alpha
A3: Bravo
A4: Charlie
A5: Echo
Is that what you're looking for?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"lhouck12" wrote in message
...
I have information in a single row. I want to create a formula and
extend
it
to an entire column but I want the cell value in the formula to extend
by
row.
|