Is the second page also meant to refer to 'date details'?

--
HTH

Bob

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

"stew" wrote in message
...
Dear Bob

Works on the first page but does not copy and paste on the second page
succesfully

any thoughts?

Stew

"Bob Phillips" wrote:

C178: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+7,3))
H178: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+17,3))
C186: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+15,3))
H186: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+25,3))
C188: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+39,3))
H188: =INDIRECT("'date details'!"&ADDRESS((INT(ROW()/24)-7)*45+55,3))

--
HTH

Bob

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

"stew" wrote in message
...
Dear bob

The answer that you gave me works Perfectly for what I needed which was
For
the formula to roll on Individual pieces of information on to cells
whose
address in crease by 80 every time. However it has worked so well it
gives
me
another application for it but I cannot quite get it to work Perhaps
you
could Help

This is the page layout for an Itininary that is 300 daily pages long
each
cell is repeated in an 49 row increase when the C address changes to
an D
Address and then 49 more and then an E Address etc etc. Hope I have
explained myself well enough

In C178 I HAVE ='DATE DETAILS'!C7 IN H178 I HAVE ='DATE
DETAILS'!C17
this column runs through to This column runs
through
to
C186 in which is='DATE DETAILS'!C15 H186 in which is ='date
details'!C25
This column then restarts on This column restarts on
C188 in which is ='DATE DETAILS'!C39 H188 in which is ='date
details'!C55
This then runs through to This column runs
through
to
C202 In which is=DATE DETAILS'!C52 H202 in which is='DATE
DETAILS'!C68
This column then restarts on
C208 In which is='DATE DETAILS'!C70
This then runs through to
C220 Inwhich is ='DATE DETAILS'!C82

THANK YOU AGAIN FOR ALL THE HELP YOU HAVE GIVEN

"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