srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
I have department number in column A, department name in column B and under each department I am adding description of budgeted expense, such as payroll, supplies, travel etc. I will put the total budgeted amount in the corresponding cell. So, for example, department name G & A Direct, in cell, B4 the budgeted total amount will be in C4 and the breakdown of the expense will be under it. I have around 60 departments and on average 15 expenses. Therefore I want to collapse the expense as it is possible in pivot table.
Can I do expand and collapse in the column, or is there a better way of doing this worksheet.
Regards,
Can I do expand and collapse in the column, or is there a better way of doing this worksheet.
Regards,