| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating a page of formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeating a page of formula
ignore this . text has gone out of line. i will try again
"stew" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeating a page of formula
You have a response at your previous thread.
stew wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeating a page of formula
My e-mail bounced back. Do you have a new e-mail
"Dave Peterson" wrote: You have a response at your previous thread. stew wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeating first Row AND first column on every page | Excel Discussion (Misc queries) | |||
| Repeating the Row Headers on each page | Excel Discussion (Misc queries) | |||
| Repeating rows on new page | Excel Discussion (Misc queries) | |||
| Repeating data from page to page | Setting up and Configuration of Excel | |||
| repeating a row at top of page | Excel Discussion (Misc queries) | |||
Linear Mode
