| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
| select block of rows w/data between blank rows | Excel Programming | |||
![jgmiddel[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
