Joy,
I must be missing something. See my inline comments below
thank you
the problem is I do not want to keep outline structure, but I wish to
renumber.
this is my other post:
then you may get what I really want. thanks
in our ms project, we have a field called task_order.
suppose we have a ms project:
WBS order
1 1
1.1 2
2 3
3 4
now we add onw task 1.2 in server and import some data (in csv file). the
data is:
WBS order
1 1
1.1 2
2 4
3 5
1.2 3
[John] I assume the "order" numbers you show above are the IDs. Then I'm
confused because WBS 1.2 already has a Task ID of 3 which is what you
want. If the order numbers are not the ID then what are they?
then we do sort, in ms project file, it looks like this:
WBS order
1 1
1.1 2
2 4
3 5
1.2 3
[John] What exactly did you sort? This sequence is identical to the
sequence before the sort.
it seems that ms project do sort within each summary task. I am curious
whether it treats 1.2 as a sub task as task 3 instead of task 1.
[John] That's true, Project will only renumber within the outline
structure. However, if for some reason WBS 1.2 is being indentured under
WBS 3 (due to the append from the server and/or csv file), then you may
have to outdent it before the sort so that you can renumber within the
outline structure.
John
Project MVP
:
after some operation, ms project looks like:
WBS ID Name outline level
1 1 new2 1
1.1 2 new2 1 2
1.2 4 new2 2 2
2 3 new1 1
This is the right order I want. The issue is, can I possibly find a
way
to
let ID be ordered.
Like the above example, it is 1, 2, 4, 3
What I want is 1, 2, 3, 4:
WBS ID Name outline level
1 1 new2 1
1.1 2 new2 1 2
1.2 3 new2 2 2
2 4 new1 1
It seems ID cannot be changed, it is read only... thanks
Joy,
Yes the Task ID can be changed, you just have to do it in the right
way.
It looks like you have a WBS structure that you want to be the driving
factor. Go to Project/Sort/Sort By and set the criteria as WBS. Then
check both options at the bottom of the Sort window to keep the outline
structure and permanently renumber tasks.
This can all be done using the Sort Method in VBA.
Hope this helps.
John
Project MVP
