View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default Help with indirect

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