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.
I want to create a formula that references x. Then I want to copy and past
this formula in a column but I want the reference to increase by row so that
when I copy and paste it looks like this
x
xx
xxx
xxxx
Say x is orginally in cell A1. If I copy and paste down it would increment
to A2, A3, etc. I want the incrementation to be B1, C1, C1, etc even though I
am copy to different rows I want it to increment the column position.
You're welcome......I'm glad I could help
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.