Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
Custom Header | Excel Discussion (Misc queries) | |||
Selecting Data for report | Excel Worksheet Functions |