Forum Discussion

Yann-78's avatar
Yann-78
Copper Contributor
Oct 18, 2022

Copy paste cost rate table across resources

Hi,

I am trying to copy paste the cost rate table customized for each year across resources. The default cost rate as 1 dimension can be pasted un the grid view but the cost rate varying over time needs to be entered manually for each resource. Any idea? 

  • John-project's avatar
    John-project
    Silver Contributor
    Oct 18, 2022
    Yann-78,
    As you found out it is not possible to use copy/paste to transfer cost rate table information across all resources. It can be done manually or, it can also be done with VBA. If you have only a few resources and only a couple of years data, setting it up manually isn't too difficult. However, if you have several resources with a multi-year cost rate plan, then VBA is the best approach.

    John

Resources