Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to sum monthly or weekly reports into one report
I would like to do monthly or weekly reports but have the data enter into a
yearly summary excell itemized reoprt. Is there a way to do this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to sum monthly or weekly reports into one report
I'll assume you have a date in column A of your report. I would add two
additional columns to your worksheet. The 1st beeing the weeknum. Add the formula =WeekNum(A1) to the 1st new column and copy down the column. In the 2nd new column add the formula =Month(A1) and copy down the column. Then you can add a autofilter to the two new columns (Data - filter - Autofilter). You can then filter your speadsheet on either month or week num to get the data. You can copy the worksheet to a new worksheet after applying a filter. "David" wrote: I would like to do monthly or weekly reports but have the data enter into a yearly summary excell itemized reoprt. Is there a way to do this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to sum monthly or weekly reports into one repor
Thanks Joel, but what I'd like to do is to take an exisiting 2 page expense
report and create a one page summary report and be able to add tabs in between. Probably more work than I really want to do. "Joel" wrote: I'll assume you have a date in column A of your report. I would add two additional columns to your worksheet. The 1st beeing the weeknum. Add the formula =WeekNum(A1) to the 1st new column and copy down the column. In the 2nd new column add the formula =Month(A1) and copy down the column. Then you can add a autofilter to the two new columns (Data - filter - Autofilter). You can then filter your speadsheet on either month or week num to get the data. You can copy the worksheet to a new worksheet after applying a filter. "David" wrote: I would like to do monthly or weekly reports but have the data enter into a yearly summary excell itemized reoprt. Is there a way to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Macros for Daily, Weekly and Monthly Reports. | Excel Discussion (Misc queries) | |||
Monthly dates on Reports | Excel Discussion (Misc queries) | |||
HOW TO MAKE WEEKLY,MONTHLY,ANNUALLY INCOME AND EXPENSE REPORT | Excel Discussion (Misc queries) | |||
Weekly and Monthly Subtotals | Excel Discussion (Misc queries) |