Thanks so much. I need more time with EXCEL.

I am using repeat rows for the top. But, I have links in the repeat rows
that display the date of the data, which organization the report is for, and
other important info. Now I have 4 pages filled in with data, in an 8 page
template. When I print Active Sheets - 1 - 4, the report says Page 1 of
8, not Page 1 of 4. This will be confusing to my users. Especially when it
will say Page 1 of 256, when I enlarge the workbook to 256 pages . I think
the links make the entire workbook active, or something.

When I save the report to a file it saves all 8 pages. I will just delete
the extra pages without data. (I will have to delete 250 pages in the
future, when I enlarge the template as big as it might get. Ugh. How
tedious.)

I find EXCEL is not as automated as I would like. I guess I need to learn
VBA to do things automatically, like tell EXCEL every time it reads in a file
that it is delimited by commas. Since all my files are, I would like to save
this as a default.

Thanks again.

"CyberTaz" wrote:

Hello again-

Glad the info was useful, but I get the impression that one important point
has not been emphasized. There is no need to format 200 pages because Excel
does not use pages as we think of them.

Page Setup is used to specify Margins, Page Orientation, Headers/Footers,
etc. for the entire WorkBook file. The actual number of pages that get
printed depends on the number of records (rows with content) on a worksheet
that will fit on a page of paper. It doesn't matter if there is only one page
or 1,000 pages, the same specs will be used for each page.

If you have content on another worksheet, the same Page Setup specifications
will be used when you print that worksheet's content unless you change them
for some reason (due to a different type of data content, for example).
Copying & Pasting Page Setup settings is not only unnecessary, but can't be
done.

Regards |:)

"judypudy" wrote:

Thank you so much! I am new to Excel, and what are are saying about the
Print dialog box should work for my report. But I think I still must format
all 200 pages or so in Excel, in case my report is that long. If I do a copy
and Paste Special, etc., 6 times then my 4 page report will become 256
pages. Then I will just print the Active sheets! It should work.
Thanks again!


"CyberTaz" wrote:

Hi Judy-

Perhaps I'm missing something, but there should not be any need for
adjustment. The number of pages will be based on the number of records being
printed as long as you have not set a specific Print Area and you choose
Active Sheet(s) in the Print dialog box (and assuming there is no other
content elsewhere on the sheet).

One thing you may want to add in your template, if not already done, is go
to FilePage SetupSheet (not thru Print Preview) and specify Rows to Repeat
at Top in the Print Titles section so that your captions will reprint at the
top of the columns if more than one page of data is being printed.

Please post back with more specifics if this is not sufficient.

HTH |:)

"judypudy" wrote:

I have an Excel template in which I import data that is of varying records.
Sometimes there are 3 records, sometimes there are 50 or 200 records. I do
not know how to make a varying page Excel report.
(For example, my clients sometimes want to see data on top 3 occupations,
sometimes on top 50 occupations.)
(The template is formatted, has headers, footers, a few links, works fine.)
Using Excel 2002.