Help with reporting

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.
 
D

dlw

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top