Hi all

In Row 490 Column H I have the following

=INDIRECT("'Road Cash
Accounting'!"&ADDRESS(INT(ROW()/49),(INT(COLUMN()+1)))),0)

This displays the value in 'Road Cash Accounting'$I$10

How can I adapt the above formula in cell Row 539 Column H ( 49 rows on.
This repeats every 49 rows) to pick out 'Road Cash Accounting'$I$52 ( 42
lines on. This repeats every 42 lines)

Hope someone can help

Best

Stew