Copy range from other sheet

[PopKorn1978]

Hi guys, new to the forum and I need a little help.

Here is my issue:
in cell B99 the formula is =B98+SUM('SAV Daily'!B25:B29)-SUM('SAV Daily'!C25:C29)
I want to copy/paste the formula to B100 and I get
=B99+SUM('SAV Daily'!B26:B30)-SUM('SAV Daily'!C26:C30)
But I want this result
=B99+SUM('SAV Daily'!B30:B34)-SUM('SAV Daily'!C30:C34)

How can it be done without doing VB

Thanks

[Ace_XL]

In first cell

=B98+SUM(INDEX('SAV Daily'!B:B,20+ROW(A1)*5):INDEX('SAV Daily'!B:B,24+ROW(A1)*5))-SUM(INDEX('SAV Daily'!C:C,20+ROW(A1)*5):INDEX('SAV Daily'!C:C,24+ROW(A1)*5))

Copy down

[Pete_UK]

Put this in B99:

=B98+SUM(INDIRECT("'SAV Daily'!B"&20+ROWS($1:1)*5&":B"&24+ROWS($1:1)*5)-SUM(INDIRECT("'SAV Daily'!C"&20+ROWS($1:1)*5&":C"&24+ROWS($1:1)*5)

then you will be able to copy it down to successive rows.

Hope this helps.

Pete

[PopKorn1978]

Thanks guy, that is very helpful and learnful