Work breakdown structure sorting....

[nparsons75]

Hi, I have a gantt chart that i have created in excel and would like to be able to reorder rows based on the work breakdown structure numbering. So, as an example, the gantt chart consists of 30 rows of data. The ordering for the rows needs to be determined by the numbering system in column A and Column B. In column A is the main title or task number. In column B is the sub task number. Example below.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3.2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So, what i need to be able to do, if a user needs to re-number the rows to reorder them, they will simply change the number. Once the number has been changed they can press a button which will then re-order the whole table based on the two numbers in column A and B. For example, should the user realise 3.2 should be 2.5, they amend the number, press the button and everything is reordered to suit.

Is that even possible??

The table consists of approx 25 columns with it being a gantt chart, the above table is just an example of how the numbering system has been setup.

Thank you in advance and fingers crossed....

 

[oldbrewer]

ok so 3.2 is now 2.5
sort by first col A then col B and whatever in col C will follow
are blanks against 1,2,3 necessary ?

 

[oldbrewer]

[TABLE="width: 1024"]
<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1[/TD]
[TD="class: xl22, width: 64, align: right"]1[/TD]
[TD="width: 64"]words1[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]original[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]words1[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1.1[/TD]
[TD]words2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.1[/TD]
[TD]words2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1.2[/TD]
[TD]words3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.2[/TD]
[TD]words3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl22, align: right"]2[/TD]
[TD]words4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]words4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.1[/TD]
[TD]words5[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]B1=A1 font color white etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2.1[/TD]
[TD]words5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.2[/TD]
[TD]words6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2.2[/TD]
[TD]words6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.3[/TD]
[TD]words7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2.3[/TD]
[TD]words7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.4[/TD]
[TD]words8[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]sorted by col B ascending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2.4[/TD]
[TD]words8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.5[/TD]
[TD]words11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]words9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="class: xl22, align: right"]3[/TD]
[TD]words9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3.1[/TD]
[TD]words10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3.1[/TD]
[TD]words10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2.5[/TD]
[TD]words11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[nparsons75]

Hi, Thanks for the reply. No, blanks are not necessary, good point. So, after trying this I get a message saying to do this all merged cells must be the same size?

 

[oldbrewer]

there are no merged cells, are there ?