none
Auto fill standard rate RRS feed

  • Question

  • If I create a custom lookup column in Project 2007 that lists the different rate level and rates for resources can the selected rate automatically fill the Standard Rate field in the resource sheet?
    Tuesday, March 6, 2012 10:00 AM

Answers

  • Hi,

    yes, it is possible, but only by code (VBA macro). It can be set with Res.StandardRate =25, for example.
    You can just use a formula for that, unfortunately.

    Let us know, if you need assistance on this.

    Regards
    Barbara

    • Marked as answer by fitzhay Tuesday, March 6, 2012 11:37 PM
    Tuesday, March 6, 2012 10:34 AM
    Moderator

All replies

  • Hi,

    yes, it is possible, but only by code (VBA macro). It can be set with Res.StandardRate =25, for example.
    You can just use a formula for that, unfortunately.

    Let us know, if you need assistance on this.

    Regards
    Barbara

    • Marked as answer by fitzhay Tuesday, March 6, 2012 11:37 PM
    Tuesday, March 6, 2012 10:34 AM
    Moderator
  • Thanks Barbara.  I suspected that was the case. Appreciate your answer and offer of help. 
    Tuesday, March 6, 2012 11:37 PM