Marco: I took a look at the .xls link that you gave me, but not sure how
that would work in this application. I can have a table full of all the
information for all 100 factories. What I want is a separate spreadsheet file
for each of those 100 factories. In each file there will be one page (sheet)
with all that factory's data. An example of the data could be:
product line 1
Model 1 description of model1 1,000 active 15
Model 2 description of model 2 2,000 inactive 30
--------
----
3,000
45
product line 2
.... etc
Report footer: 150,000 200
I don't see how pivot tables could get the data into that format without
the user doing some work themselves... Writing code to stick the data into a
.csv files great, giving me lines for the break headers, the footers. The
only problem is that she has to bring up 100 files, run a macro to format,
save as .xls.
Karen
> With Pivot you can add a print page break for every category of for each
> page filter a report as tab automatic made by Excel.
>
