Stew,

Don't use INDIRECT.

In A690, use

='Road Cash Accounting'!A11

and copy that to A722. Excel will update the formula to

='Road Cash Accounting'!A43

etc.

HTH,
Bernie
MS Excel MVP


"stew" wrote in message
...
Hi all

I am using this Formula in worksheet sheet 1 A690
=INDIRECT("'Road Cash Accounting'!"&ADDRESS(ROW()/6-104,(COLUMN()))) to get
to A11 in Road cash accounting.
I am having difficulty adapting to make it repetitive in the following manner

In Worksheet sheet 1 A722 ,A690+32 Rows
has to display
In road cash accounting A114, A11+103 Rows
and again
In worksheet sheet 1 A754 , A722+32 Rows
Has To Display
In Road Cash Accounting A217,A114+103 Rows

And so on

Hope you can help

Stew