Importing cost rate table data from Excel

[Lakshmi11]

Hello

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.

Thanks

[#2]

Lakshmi11,
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.

John