can you use something like words "includes" in excel
To create a book in word you can use "includes" to build the different phases
of the book. I am creating a multiple page census report in excel, the bigger it gets the more it crashes, can I make separate files and use something like "includes" combine all pages in printed copy of the book. Mary Ellis |
can you use something like words "includes" in excel
IF???
you mean you are creating multiple pages of the same thing with different data you should consider using a macro to populate ONE report and print from there. A looping macro could do all. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mary Ellis" wrote in message ... To create a book in word you can use "includes" to build the different phases of the book. I am creating a multiple page census report in excel, the bigger it gets the more it crashes, can I make separate files and use something like "includes" combine all pages in printed copy of the book. Mary Ellis |
can you use something like words "includes" in excel
What I am doing is this. If you look at each form for the US Census
every one is different (10 year span between census') I have started at the earliest, 1790, and have followed a family through to the 1930 census so I have a different form for every 10 years (except for 1890 that year is missing from the National Archives) anyway, some years can be 18-20 pages more or less when paginated for print ... I finally made a pdf file from the last excel book and it was 187 pages. This excel workbook crashed numerous times, one of those times I started wondering if excel uses 'Includes' like Word does.. I don't understand the loop idea you mentioned since the names, dates, ages, people and all other data can change and will change from each census record. Thanks again for the reply... Mary On Dec 24 2008, 8:45*am, "Don Guillett" wrote: IF??? you mean you are creating multiple pages of the same thing with different data you should consider using a macro to populate ONE report and print from there. A looping macro could do all. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mary Ellis" wrote in message ... To create a book in word you can use "includes" to build the different phases of the book. *I am creating a multiple page census report in excel, the bigger it gets the more it crashes, can I make separate files and use something like "includes" combine all pages in printed copy of the book.. Mary Ellis |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com