Excel - Grouping pre sorted data based on column values

[ASH2012]

I have a table with data sorted into rows for review, rows that are ok and rows that are other, between each data set is a blank row. I want to run a macro that:

1. extracts the data for a person(I've got this),
2. groups the data by review/OK/other , closing(hiding) 'Ok' and 'other' groupings, the number of rows is variable in these groups with 'other' often having no entries at all (Help!!!!)
3. exports to a new file ready to be saved(I've got this)

If anybody can help it would be great...

 

[ASH2012]

I have got this far:

Dim ReviewStartRow As Integer, ReviewEndRow As Integer
With Sheets("FD Export")
ReviewStartRow = .Range("B:B").Find(what:="Review", after:=.Range("B4")).Row
ReviewEndRow = .Range("B:B").Find(what:="Review", after:=.Range("B4"), searchdirection:=xlPrevious).Row
End With

But fail when I use the integers to select the rows...

Rows(ReviewStartRow:ReviewEndRow).Select