Forum Discussion
Importing cost rate table data from Excel
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
- 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
