R
Robbro
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.
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.