Hi,
Good day!
I want to drag a formula from a horizontal cell but I want to paste it in a vertical cells.
Example: I want to drag a formula in cell A4 to A27 from cell A1 to X1.
cell A4 = A1
cell A5 = B1
.
.
.
cell A27 = X1
Hi,
Good day!
I want to drag a formula from a horizontal cell but I want to paste it in a vertical cells.
Example: I want to drag a formula in cell A4 to A27 from cell A1 to X1.
cell A4 = A1
cell A5 = B1
.
.
.
cell A27 = X1
Try this in A4, copied down as needed...
=OFFSET($A$1,0,ROWS($A$1:A1)-1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FormuleFormula:=INDEX($A$4:$A$27;COLUMNS($A:A))
Hi FDibbins and Czeslaw,
You guys save my day! It works! CHEERS..
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks