Hi, Maybe your use the Pivot feature in Excel 2003 / 2007 or 2010 where you can have all data available and where you can add a page filter for the 100 departments to show only their own data.
The data in Excel van be automatic updated with data from a R:BASE databas with use of ODBC. I have added a very simple sample based on Oterro sample database in Excel as pivot: http://www.rbase.eu/files/oterro_pivot.xls With Excel 2007 or even Excel 2010 (PowerPivot) you can be more flexible. Marco ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List Sent: Tuesday, March 09, 2010 8:02 PM Subject: [RBASE-L] - Re: Reports to Excel Jason: I'll have to find out from their IT guy if he knows how to do that! I don't have a copy of the spreadsheet/macro that they use... Karen If there is already a macro/VBA module written that formats one file, it is not too difficult to modify it to open each file, format it, and save it. This is not quite the same as having each report generated in its final format, but it will allow the end user to only run the macro once, instead of manually processing all 100 files. If you have a copy of the macro/VBA module, I can help you out. I have some VBA and VB Script experience. Jason
