Forum Discussion

Lakshmi11's avatar
Lakshmi11
Copper Contributor
Jul 20, 2023

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

  • John-project's avatar
    John-project
    Silver Contributor
    Jul 20, 2023
    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

Share