Karen,
I don't fiddle with Excel much, but I have mucked around a bit with the
VBA in a few of the Office products. I am not certain that simple Macros
the IT guy has formulated are sophisticated enough to detect and propogate
the slight variances in each dataset as it relates to factor number, but I
am certain that VBA can do it, even though I haven't done it. This is what
the Visual Basic for Applications language is used for in the Office apps.
You have some Visual Basic background and it shouldn't be much of a
stretch for you to look at the Object Model of the Spread Sheet and do it.
Get Crackin..
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, March 09, 2010 5:51 PM
Subject: [RBASE-L] - Re: Reports to Excel
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.
