Sorting data exported from Crystal Report

[JoshBrunz]

I have a crystal report that list customers from different locations.
The format is simple. 1 row will have the name of an office. lets say
'office 1'. then it will have a list of the customers in column a.
eventually 'office 2' will be in column a followed by their list of
customers. 5 offices total. i import the sheet created by crystal into a
table in sheet1 of a new spreadsheet. now i need to split that table
into 5 sheets. sheet2 will be office 1 and their customers. sheet3 will
have office 2. etc. i have used address/match and can get the cell
location of office 1, office 2 from the 1st sheet.

how do i get the range of cells between office 1 and office 2 on sheet2?




--
JoshBrunz