G
Guest
Hello,
I have a problem while dragging the formula to the next cells.
The formula in A1 of sheet 1 is ='Sheet2'!C34
The formula in B1 of sheet 1 is ='Sheet2'!F34
The formula in C1 of sheet 1 is ='Sheet2'!I34
Here while dragging the formula, the next cell has to take the value of the
same row (34) of every third column C, F, I, L... so on. But while dragging
its not coming the same way.
Can anyone suggest me how to do that?
Thanks in advance
Sasikiran
I have a problem while dragging the formula to the next cells.
The formula in A1 of sheet 1 is ='Sheet2'!C34
The formula in B1 of sheet 1 is ='Sheet2'!F34
The formula in C1 of sheet 1 is ='Sheet2'!I34
Here while dragging the formula, the next cell has to take the value of the
same row (34) of every third column C, F, I, L... so on. But while dragging
its not coming the same way.
Can anyone suggest me how to do that?
Thanks in advance
Sasikiran