Sailinhorse
Chemical
Can one import a "% Work Complete" value generated in Excel into Project 2000? If not can you import the value into a Project "Number x" column?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing from Excel
- Thread starter Sailinhorse
- Start date
- Status
cosmicchris
Mechanical
Please excuse me if you already know how to perform this, but I find it a useful and very fast way of updating programmes.
Insert a column and define the field name as "% Work Complete" (if the column inserted is placed next to the ID or name it is easy to check the entry is at the corect position). The % complete information can then be entered, supermarket checkout style, using the numeric keyboard. The % complete column can then be hidden, if required.
The copy and paste command is fine too but very often it can cause problems if the paste is out by one row.
Insert a column and define the field name as "% Work Complete" (if the column inserted is placed next to the ID or name it is easy to check the entry is at the corect position). The % complete information can then be entered, supermarket checkout style, using the numeric keyboard. The % complete column can then be hidden, if required.
The copy and paste command is fine too but very often it can cause problems if the paste is out by one row.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
