Excel 2010 VBA Help: Grouping Rows by text in A Column.

First, Hello everyone.
I am working in Excel 2010 and I have 175550 rows, but only 6 columns.

I need to scan each row Starting in Column A2, and if A3 matches, keep going until you don't get a match. (Once they don't match, you won't get another one that matches)
Once the next column doesn't match add a Row, Paste the same Name from above into the new Row in A column, group all that matched and last step place a count in Same Row, Column F. Then continue until a blank A Cell exists.

Here's my example:

a1 - f1 title row. Numbers on left are Row Numbers for example, A2 is "Test", Data in B,C,D,E,F doesn't matter.

1 Test B C D E F
2 Test B C D E F
3 Test B C D E F
4 Test1 B C D E F
5 Test1 B C D E F
6 Test1 B C D E F
7 Test1 B C D E F
8 Test1 B C D E F

what I want it to look like:

Leave A1 - F1 row.
+ 4 Test - - - - 3
+10 Test1 - - - - 5

The + is the grouping. Columns B C D E can be left blank, F just needs the total of all the rows we grouped (the count of matches) excluding the display row(the one we added).

Thank you,

Originally Posted by alansidman

This is a built in function of Excel. It is called sub-totals.

Here is a link on how to do it.

http://office.microsoft.com/en-us/ex...010342620.aspx

http://www.videojug.com/film/how-to-...otals-in-excel

Thank you very much, I didn't know this would work. Much appreciated.