Cost rate tables help

A

arectoo

Hi, I have a resource pool with over 2k employees and I need to update
Cost Rate Table B.

The rates used in the Cost Rate Tables are determined by the each
resource's code (stored in the resource Code field). There are about
100 total codes and no Overtime or Per Use Cost fields. Following is
an example of a resource code with its rates.

Code = 1.ABC
With effective date = current
Standard Rate = $50/h
With effective date = 1/1/08
Standard Rate = $52/h
With effective date = 1/1/09
Standard Rate = $53/h

So, if

Resource name = Joe
Code = 1.ABC

I need to enter the rates for 1.ABC into Cost Rate Table B.

Can someone please assist with some starter VBA code to accomplish
this? I am new to VB.

Thank you for any guidance!
 
M

Mike Glen

Hi arectoo,

Try posting on the developer newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP
 
A

arectoo

Hi arectoo,

Try posting on the developer newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web
address:http://project.mvps.org/faqs.htm.

Mike Glen
Project MVP
Click to expand...

Hi Mike,

Thank you for that direction! I will do that.

RC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cost rate tables help? 2
Maintenance of Cost Rate Tables in MS Project 2010 0
Add custom cost rate to rate tables 2
Cost Rate Table Macro request… 5
Resource Rate used for a specific Assignment (Project 2003) 5
Resource Rates 3
Summary of Costs based on Cost Rate Tables applied 4
Find cost rate table information in PS 2007 8

Top