Using office 2007 and I have a monthly report I will be preparing. It has
the following structure

Customer A
product 1 from plant 1 data data etc
product 2 from plant 1 data data etc
subtotal
no sub

product 3 from plant 2 data data
etc...
subtotal
no sub

customer
total no total

and on and on for thousands of rows. Certain columns will have sub-totals
and totals, others will have none. I asked about pivot tables yesterday,
because they come very near to giving me what I need, only they subtotal and
total either every column or no columns which is not acceptable to the users
of the report. I'm spending a good bit of time formatting on this report, it
comes in just as solid info and I go through inserting rows between plants
and customers and manually adding sub totals and totals where appropriate.
Other than pivot tables is there any other way to automate or speed up this
process? Naturally every month the customers and products change somewhat.

If you have Access, you could link to the spreadsheet with the raw data, then
use the Access Report Wizard to do the reports.

"Robbro" wrote:

Using office 2007 and I have a monthly report I will be preparing. It has
the following structure

Customer A
product 1 from plant 1 data data etc
product 2 from plant 1 data data etc
subtotal
no sub

product 3 from plant 2 data data
etc...
subtotal
no sub

customer
total no total

and on and on for thousands of rows. Certain columns will have sub-totals
and totals, others will have none. I asked about pivot tables yesterday,
because they come very near to giving me what I need, only they subtotal and
total either every column or no columns which is not acceptable to the users
of the report. I'm spending a good bit of time formatting on this report, it
comes in just as solid info and I go through inserting rows between plants
and customers and manually adding sub totals and totals where appropriate.
Other than pivot tables is there any other way to automate or speed up this
process? Naturally every month the customers and products change somewhat.