Rate based on role

%3CLINGO-SUB%20id%3D%22lingo-sub-978287%22%20slang%3D%22en-US%22%3ERate%20based%20on%20role%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978287%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20change%20resource%20rates%20based%20on%20their%20role.%20I'm%20having%20to%20do%20about%201%2C000%20changes%20and%20an%20effective%20date%20of%201%2F1%2F2020.%20If%20anyone%20knew%20a%20simpler%20way%20to%20do%20this%20it%20would%20be%20much%20appreciated.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006925%22%20slang%3D%22en-US%22%3ERe%3A%20Rate%20based%20on%20role%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424058%22%20target%3D%22_blank%22%3E%40cmill262%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20select%20the%20group%20of%20resources%20in%20resource%20centre%20by%20applying%20desired%20filter%20(in%20your%20case%20based%20on%20role)%20then%20select%20to%20edit%20in%20desktop%20app.%20in%20the%20desktop%20app%20(Project%20Pro)%20you%20can%20build%20a%20view%20with%20all%20the%20fields%20you%20want%20to%20edit%20and%20then%20work%20like%20an%20Excel%20spreadsheet%20(dragging%20values%2C%20copy%20and%20paste%20from%20another%20Excel%20file%2C%20and%20etc.)%20and%20finally%20publish%20the%20changes%20to%20the%20server%2Fcloud.%3C%2FP%3E%3CP%3EObviously%2C%20setting%20up%20the%20views%20will%20take%20some%20time%20but%20you%20save%20a%20lot%20of%20time%20at%20the%20end%20and%20no%20requirement%20for%20any%20codes%20or%203rd%20party%20tool.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1008482%22%20slang%3D%22en-US%22%3ERe%3A%20Rate%20based%20on%20role%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1008482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331771%22%20target%3D%22_blank%22%3E%40Naaser%3C%2FA%3E%26nbsp%3BHi%20thank%20you%20so%20much%20for%20the%20response.%20I%20was%20actually%20able%20to%20find%20a%20way%20to%20do%20it%20using%20vba%20code%20to%20add%20a%20effective%20rate%20change.%20If%20anyone%20wants%20to%20see%20it%20just%20reply%20to%20this%20and%20I'll%20post%20a%20screenshot%20to%20help%20anyone%20in%20the%20same%20situation.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1011152%22%20slang%3D%22en-US%22%3ERe%3A%20Rate%20based%20on%20role%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1011152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424058%22%20target%3D%22_blank%22%3E%40cmill262%3C%2FA%3E%26nbsp%3BNo%20worries%2C%3C%2FP%3E%3CP%3ESo%20it%20seems%20I%20replied%20to%20you%20with%20a%20wrong%20assumption%20that%20you%20are%20using%20Project%20Server%2FProject%20Online%20and%20updating%20bulk%20of%20resources%20in%20the%20Enterprise%20Resource%20Pool%20is%20the%20concern.%26nbsp%3B%3C%2FP%3E%3CP%3ESurely%2C%20while%20you%20have%20the%20data%20in%20your%20file%2C%20Macros%20will%20make%20it%20easier%20to%20apply%20bulk%20updates.%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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. Thank you.

3 Replies

@cmill262 

I would select the group of resources in resource centre by applying desired filter (in your case based on role) then select to edit in desktop app. in the desktop app (Project Pro) you can build a view with all the fields you want to edit and then work like an Excel spreadsheet (dragging values, copy and paste from another Excel file, and etc.) and finally publish the changes to the server/cloud.

Obviously, setting up the views will take some time but you save a lot of time at the end and no requirement for any codes or 3rd party tool.    

@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. 

@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!