View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Increasing cell address by a set amount

Column C (3) is your base.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stew" wrote in message
...
Dear Bob

Thank you. This does the Job. So now I am trying learn why. Why +3. The
rest I think I have got

Best

Stew

"Bob Phillips" wrote:

B8: =INDIRECT("'date details'!"&ADDRESS(5,(INT(ROW()/80)+3)))
B10: =INDIRECT("'date details'!"&ADDRESS(7,(INT(ROW()/80)+3)))
B11: =INDIRECT("'date details'!"&ADDRESS(3,(INT(ROW()/80)+3)))
B14: =INDIRECT("'date details'!"&ADDRESS(16,(INT(ROW()/80)+3)))

and so on

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"stew" wrote in message
...

Dear All

I was orginally helped with a similar problem by Sandy Mann but I have
come
to grief again. Can anybody give a formula that can do the Business

In b8 I have ' date details'!c5
In b10 I have 'date details'!c7
In b11 I have 'date details'!c3
In b14 I have 'date details'!c16

In b88 I wan to have ' date details'!d5
In b90 I want to have 'date details'!d7
In b91 I want to have 'date details'!d3
In b94 I want to have 'date details'!d16

In b168 I wan to have ' date details'!e5
In b170 I want to have 'date details'!e7
In b171 I want to have 'date details'!e3
In b174 I want to have 'date details'!e16

and on and on

Thanks in advance for looking