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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com