Hi, Which Excel 2003, 2007 are the people using ?
By the way why are you not using the R:BASE Report features and have the output for all 100 factories on screen in pdf or in xls format for the customer ? I am sure this is possible for users to choice from screen or by automatic procedure to make 100 excel sheets for the 100 factories in R:BASE Marco ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List Sent: Tuesday, March 09, 2010 11: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.
