Jenn said:
I have an excel spreadsheet that has 4 fields: employee name, hrly cost for
Project 1, hrly cost for Project 2, and hrly cost for Project 3. I would
like to be able to import these costs into the A, B, & C sub tabs in the
resource form under the cost tab. Is this doable?
TIA!
Jenn,
Most definitely. There are basically three approaches.
The first is to copy and paste the data from Excel to Project. A bit
tedious, but effective.
The second is to use an import table. This will work as long as the data
is arranged in columns in Excel. For example, resource names are in
column "A", pay rate for Project 1 is in column "B", etc. Then in
Project go to File/Open and select Excel Workbook as the file type. When
you hit "Open" the import wizard will appear. Set up the import table to
import resources and map the first pay rate into the Standard Rate field
of Project. I would import the other pay rates into spare text fields.
After the import is complete, manually copy the pay rates from the text
fields into the B, C, etc. sub tabs of the cost rate table.
A third approach is to use VBA. This only works of course if you know
how to write macros but it does offer the flexibility of doing the whole
process automatically.
Hope this helps.
John
Project MVP
