Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba for excel training - Organising a worksheet
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba for excel training - Organising a worksheet
Resolved · Low Priority · Version Standard
Reply Thu 1 Nov 2007, 11:06Delegate Ashraful said...
Ashraful has attended:
Excel Advanced course
Organising a worksheet
I am working with a worksheet and have data from several countries in my file. I have put in an autofilter but I want to be able to group each country individually so the overall figures show for that country but have the fucntion whereby when you click it drops down to give a detailed breakdown of the data.
I remember doing something similar on the course bu don't have my manual to hand.
For upcoming training course dates see: Pricing & availability
RE: Organising a worksheet
Hi Ashraful
Thank you for your question.
I think by the sounds of what you are wanting to do that you need to use the Subtotals feature in Excel.
Here's how:
1. Select any cell in the column containing the countries.
2. Sort this column so the rows for each country are listed together.
3. Go to Data - Subtotals.
4. In the At each change in box, select the heading for the column you have sorted in (2) above.
5. Leave SUM as the Function
6. Put a tick next to the column/s you want subtotals added into (the column/s you wish to see the overall totals in - these need to contain numeric data).
7. Click OK.
To see different levels of detail, click the 1, 2 or 3 button in the grey outline area on the left side of your screen.
I hope this is what you were after.
Amanda
|