Forum Discussion
cmill262
Nov 04, 2019Copper Contributor
Rate based on role
I'm looking to change resource rates based on their role. I'm having to do about 1,000 changes and an effective date of 1/1/2020. If anyone knew a simpler way to do this it would be much appreciated....
cmill262
Nov 14, 2019Copper Contributor
Naaser Hi thank you so much for the response. I was actually able to find a way to do it using vba code to add a effective rate change. If anyone wants to see it just reply to this and I'll post a screenshot to help anyone in the same situation.
Naaser
Nov 15, 2019Copper Contributor
cmill262 No worries,
So it seems I replied to you with a wrong assumption that you are using Project Server/Project Online and updating bulk of resources in the Enterprise Resource Pool is the concern.
Surely, while you have the data in your file, Macros will make it easier to apply bulk updates.
Good luck!