Summary Sheet

[Kathleen Bell]

Clear DayI have a spreadsheet which is pulled down from a database of
warehouse transactions. After the data is manipuated it is summarized in a
pivot table. There is another sheet which is called "JE ready" It has
company, department, account, category, description and amount. It is the
same as the data except that when the first four match the total is he sum
of all the items.

I suspect part of it was done by hand before (my first close in this job-
and it is year-end) because when compared to the pivot table there is always
a small difference. Is there a way I can mechanize this. It is a very large
table. I am using either 2000 or 2002 at work and do not know VBA.

 

[Guest]

Kathleen

I suspect that the error is in the original data that has not been rounded.
Add an extra column and in (say) G2 type =ROUND(f2,2) and copy this formula
down. Use this for the sums and in the Pivot Table field

Regards
Peter Atherton

 

[Kathleen Bell]

I don't think I explained well enough. You might have ten lines in the data
with the same company, department, account and category. The pivot table
organizes the data in a different way. The summary file would take that ten
lines and make one with the total as one. I can't figure out how they did
it before and the only way I can see it is doing it by hand which would
explaine the difference (which is more than just rounding would explain).

 

[comish4lif]

If you just want the total by Company, you can make a Pivot Table with
Company set as the Rows and the Transaction Amount as the Data Field -
be sure to use SUM and not COUNT or AVERAGE....