You could try
=OFFSET(Sheet2!A$1,6*(ROW()-1),0)+OFFSET(Sheet3!A$1,6*(ROW()-1),0) if your
first formula is in row 1. [If it's in a different row, change the two
occurrences of -1 to refer to the relevant row.]
Copy that down.
--
David Biddulph

"Shvraka" wrote in message
...
I would like to apply this formula to several cells in sheet:

=Sheet2!A1+Sheet3!A1

When I copy this formula to the next cell below it I would like it to
show:
=Sheet2!A7+Sheet3!A7

next cell would be:

=Sheet2!A13+Sheet3!A13

BUT when i drag the fill handle it does not follow the step (6) I gave it
to
follow?!

Thanks!