vba for excel training - 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