Autopopulating formulass horizontally?
I assume you mean,
A2: =Worksheet!I5
B2: =Worksheet!I6
One way is to have a row of numbers.. so in row 3, have 5, 6, 7 across the
row.
then, in A2:
=INDIRECT("Worksheet!I"&A3)
And copy across.
The value in cell A2 would be the value in Worsheet!I5, then B2 would be I6,
etc.
"Leonhardtk" wrote:
If I create the formula in A1:
=Worksheet!I4
I want to drag this to the right to copy the formula to other cells to the
right.
By default, A2 would equal:
=Worksheet!J4
If I procede the I4 with a $, I get the same value all accross:
A2: =Worksheet!$I4
A3: =Worksheet!$I4
How do I get
A2: =Workstheet!I5
A3: =Worksheet!I6
etc.
Thanks.
|