Entering data into various cost tables

[Larry N]

We're using Project Pro 2003 and Project Server 2003. I need to enter various rates in the cost tables for each employee. I know how to do it for an individual (using Resource Information in the Task Usage view), but is there a way I can edit (i.e. paste a column from a spreadsheet) ALL resources at once for, let's say, table B? Changing one resource at a time is painful. : (

 

[Jan De Messemaeker]

Hi Larry,

If you can insert a VBA macro in the VB Editor the following will help you
Set (for instance) cost rate table B's standard cost for each resource in
their Number1 field

Copy/Paste the following macro into a VBE module:

Sub ForLarry
dim Slave as resource
for each Slave in activeproject.resources
if not slave is nothing then
slave.costratetables("B").Payrates(1).StandardRate=slave.number1
end if
next slave
end sub

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

We're using Project Pro 2003 and Project Server 2003. I need to enter

various rates in the cost tables for each employee. I know how to do it for
an individual (using Resource Information in the Task Usage view), but is
there a way I can edit (i.e. paste a column from a spreadsheet) ALL
resources at once for, let's say, table B? Changing one resource at a time
is painful. : (

 

[Larry N]

Thanks, Jan. I will give it a try and let you know how it goes.