View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jgmiddel[_9_] jgmiddel[_9_] is offline
external usenet poster
 
Posts: 10
Default Sorting block of rows with empty rows between it

In a overview I have:

In column A projectnumbers. Projectnumbers are sorted, but projects
can exist more then 1 time. So, a project can have reveral rows. In
the columns B-G there is information about the projects.

For example: in A1-5 there are projectnumbers, all the same.In B1-G5
information about all these projectparts. Row 6 is empty. In A7-A10
thera are also projectnumbers, in B7-G10 information. Row 11 is empty
again, and so on.

What I want is a option to sort these blocks. The order of the rows in
the project must remain.

Is this possible? Any help would be appriciated.