Hi,

Im very new to writing Macos, especially when it comes to Microsoft Project. I need a specific macro that carrys out the following actions:

Lets say I have a project with the following data...

Unique ID --- Task Name --- Start --- Finish
1 --- A1 --- 01/01/11 --- 01/02/11
2 --- A2 --- 01/01/11 --- 01/02/11
3 - -- A3 --- 01/01/11 --- 01/02/11
4 --- B1 --- 01/01/11 --- 01/02/11
5 --- B2 --- 01/01/11 --- 01/02/11
6 --- C1 --- 01/01/11 --- 01/02/11
7 --- C2 --- 01/01/11 --- 01/02/11
8 --- C3 --- 01/01/11 --- 01/02/11
9 --- C4 --- 01/01/11 --- 01/02/11
10 --- D1 --- 01/01/11 --- 01/02/11

(Unique ID as an added new column)

and I import (copy/paste) the following updated schedule to the original:

Task Name --- Start --- Finish
A1 --- 01/02/11 --- 01/03/11
A2 --- 01/01/11 --- 01/02/11
B1 --- 01/01/11 --- 01/02/11
B2 --- 01/01/11 --- 01/02/11
B3 --- 01/01/11 --- 01/02/11
C1 --- 01/01/11 --- 01/02/11
C2 --- 01/02/11 --- 01/03/11
C3 --- 01/02/11 --- 01/03/11
D1 --- 01/01/11 --- 01/02/11
D2 --- 01/01/11 --- 01/02/11

I would like to update those original task's start/finish dates whilst still retaining their unique ID numbers and add+delete tasks on the updated schedule, resulting in the output:

Unique ID --- Task Name --- Start --- Finish
1 --- A1 --- 01/02/11 --- 01/03/11
2 --- A2 --- 01/01/11 --- 01/02/11
4 --- B1 --- 01/01/11 --- 01/02/11
5 --- B2 --- 01/01/11 --- 01/02/11
11 --- B3 --- 01/01/11 --- 01/02/11
6 --- C1 --- 01/01/11 --- 01/02/11
7 --- C2 --- 01/02/11 --- 01/03/11
8 --- C3 --- 01/02/11 --- 01/03/11
10 --- D1 --- 01/01/11 --- 01/02/11
11 --- A2 --- 01/01/11 --- 01/02/11

The whole purpose is to retain the unique ID number each time. This would be done for schedules with 1000s of tasks so a manual option is not viable.

Any help asap is much appreciated!