repeating a page of formula

S

stew

Dear ALL


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 . Is there on formula or 2 that I can copy and
paste.

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
C216 In which is ='DATE DETAILS'!C78
This column then restarts on
C218 in which is ='Date Details'!C80
This then runs through to
C220 Iin which is ='Date Details'!C82

THANK YOU AGAIN FOR ALL THE HELP EVERYBODY HAS GIVEN

Stew
 
D

Dave Peterson

You have a response at your previous thread.
Dear ALL

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 . Is there on formula or 2 that I can copy and
paste.

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
C216 In which is ='DATE DETAILS'!C78
This column then restarts on
C218 in which is ='Date Details'!C80
This then runs through to
C220 Iin which is ='Date Details'!C82

THANK YOU AGAIN FOR ALL THE HELP EVERYBODY HAS GIVEN

Stew
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date stamping a cell change 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Vlookup or Hlookup 7
Goto or Find a Date in a Sheet 1
Help with date formula 2
Formula question 2
Dates: Data Validation, Sumif 1
Referring to columns from within a macro 4

Top