Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Budgets
In one workbook, I may have several department sheets with many account
numbers by month. However, not all departments will have the same accounts. For example, department A may have account 1,2,3, while department B may have accounts 1,3,5. The goal is to have a summary sheet that contains all accounts by month. I could do this manually with only one or two workbooks, but I will have more workbooks than I have hours. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Budgets
Try Pivot Table..Refer http://www.contextures.com/xlPivot08.html
If this post helps click Yes --------------- Jacob Skaria "Dan" wrote: In one workbook, I may have several department sheets with many account numbers by month. However, not all departments will have the same accounts. For example, department A may have account 1,2,3, while department B may have accounts 1,3,5. The goal is to have a summary sheet that contains all accounts by month. I could do this manually with only one or two workbooks, but I will have more workbooks than I have hours. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for budgets | Excel Discussion (Misc queries) | |||
Reforecast budgets | Excel Worksheet Functions | |||
how do I set up cashflow budgets for different projects | New Users to Excel |