Importing from Excel
Importing from Excel
(OP)
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?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Importing from Excel
You can cut and paste Excel data into Project and vice versa. This is method recommended in the help
Funtime
RE: Importing from Excel
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.