Indirect Address Problem

[stew]

Hi All

Jacob Skaria Kindly helped me with this problem and I thought we had the
answer however

Small Problem with this Formula

When we reach row 960 the indirect instruction starts at 'Road Cash
Accounting'$I$10 again when it should carry on to $I$430.This applies through
to the end of the Sheet

Can Anybody help

 

[Jacob Skaria]

Try the below

(in one line...)
=INDIRECT("'Road Cash
Accounting'!"&ADDRESS(10+((ROW()-441)/49-1)*42,COLUMN()+1))

If this post helps click Yes