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. |
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. |
All times are GMT +1. The time now is 02:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com