I have lot of Excel project plans, Can anyone help me how to create Task and Sub Tasks using VBA based using excel data. this can be an Excel macro or an MPP macro.
I believe MSP uses an outline format of numbers (ie 1.1 is a subtask of 1, 1.1.1 ubstask of 1.1). In which case, you just need to know what the criteria/factor is indicating that a subtask exists, and then we can create some sort of numbering solution, either via formulas or macros.