Custom Report

I keep a file with sales and totals of each sale on a daily basis. At the
end of each month we run a report showing the totals for that month.
I have a file in Microsft Works Database that shows monthly totals. How
would I make a report in Excel to Show monthly totals?

You could use a myriad of ways, but my suggestion would be either subtotals
(Data>Subtotals...) or a pivot table (Data>Pivot table report or chart)

Post back if you need help with these

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"ClearColour" <[email protected]> wrote in message
news:[email protected]...
>I keep a file with sales and totals of each sale on a daily basis. At the
> end of each month we run a report showing the totals for that month.
> I have a file in Microsft Works Database that shows monthly totals. How
> would I make a report in Excel to Show monthly totals?

To summarize the data in a table, you can use a Pivot Table. There are
instructions in Excel's Help, and Jon Peltier has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

After you've created the pivot table, you can group the data by month.
There are instructions here:

http://www.contextures.com/xlPivot07.html


ClearColour wrote:
> I keep a file with sales and totals of each sale on a daily basis. At the
> end of each month we run a report showing the totals for that month.
> I have a file in Microsft Works Database that shows monthly totals. How
> would I make a report in Excel to Show monthly totals?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html