can you use something like words "includes" in excel

[Mary Ellis]

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

 

[Don Guillett]

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.

 

[mwellis]

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

 

[Don Guillett]

I went here and don't see what you are talking about.
http://www.census.gov/
Perhaps you can tell me or send your workbook for a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
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