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:Please Login or Register to view this content.
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