98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » vba for excel training - Organising a worksheet
vba for excel training - Organising a worksheet
Resolved · Low Priority · Version Standard
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.
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
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. |
Excel tip:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |