hi,
if i understand you....
you might try using absolute references instead of relative references.
example...
instead of ....sheet2!C34......
Use..............Sheet2!$C$34.....

Read up on absolute vs.relative references in xl help.

Regards
FSt1

"Sasikiran" wrote:

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