I have 142 projects in my T&D Program! I need to import a global code change to identify seperate engineering packages. Currently all my P&C packages have one code. I have an excell to import that has an "alpha" character to split my P&C into 3 catagories. Spreadsheet contains; Project ID, Activity ID, L-04(activity code to update), WBS.
But I cannot get it to split into the seperate projects, even if all are open. It imports all info into one project and adds the activities missing. It would be very cumbersome to have to make 142 imports and do them seperately.
Can this be done? Update all projects from one excell spreadsheet at the same time?
Also available at billy.jones2884@yahoo.com [1]