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.