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
(DataSubtotals...) or a pivot table (DataPivot table report or chart) Post back if you need help with these -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "ClearColour" wrote in message ... 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 he 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 |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com