Home |
Search |
Today's Posts |
#1
|
|||
|
|||
quarterly reports
You are going to have some problems. The Quarters do not break evenly between
weeks. Can you get a hold of the daily amounts. If so then we can set you up with at pivot table which will automatically subtotal based on weeks, months , quarters...What ever makes you heart go pitter patter... Otherwise you will have to break up 4 of your weeks that straddle the quarters. HTH "Al Vanderhoof" wrote: I have a workbook that has 52 weeks(rows) of income and expenses(columns). I'm trying to set up a quarterly reports sheet that updates from this info, but I cannot figure out how to set up the formulas that will find the dates that are in the range and save the subtotals and totals. Thanks ahead of time for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quarterly reports | Excel Discussion (Misc queries) | |||
quarterly reports | Excel Worksheet Functions | |||
How do I link specialized reports in excel? | Setting up and Configuration of Excel | |||
merging reports | Excel Discussion (Misc queries) | |||
Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) |