Gunnar: here's more details. Each factory (> 100) needs a separate spreadsheet with just their data on it. Each spreadsheet will have the requisite titles at the top and column headers. But the data will be split into multiple break headers, followed by the data, followed by break footer totals.
Yes I can create a permanent temp table to hold the raw data, and I could connect to that table from Excel (although I assume I would have to connect to it 100 different times) and bring the data into a spreadsheet. But how do I get the breakheaders to print on a separate line, and how do I get the break footers? I can't have the operator break those out because that's more work than she has to do now with the .csv file approach. Karen > Well Karen I don’t see your issue in detail. > > I need only 2 sheets in my case (Balance sheet an result sheet) I keep > them the samw workbook with different sheets, they are both updated at the > same tin when press updateall in Excel. > > For hundreds sheet I would guess you need to divide into more then one > workbook. > > Anyway if you really needs an sample on this approach, just e-mail me > privately and I will send an sample > > I can only say it has benefits and drawbacks, like in most situations > > > > Gunnar Ekblad > > > > > >
