Importing cost rate table data from Excel

Copper Contributor



I need to update cost rate table for multiple resources.

I did it manually for one resource 




Since it is a laborious process, I wanted to import it from Excel. But I dont see a mapping field for effective date and cost accrual.

Would appreciate any advise on how to proceed.


1 Reply
You are correct, there is no import field mapping for updating cost rate tables. There are two choices, for a few resources on a one-time basis, manual entry is best, but if you have a lot of resources and/or need to make updates on a periodic basis, a VBA macro is the best approach.