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!

In article <1182778160.139875.34650@q75g2000hsh.googlegroups.com>,
arectoo@gmail.com wrote:

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

arectoo,
First of all, what you want to do can certainly be automated with VBA,
but it isn't necessarily straightforward. I wrote a macro some time ago
for a client that does something very similar to what you want.

However, since you are new to VBA, I suggest you consider getting a good
book on Project VBA. Fellow MVP, Rod Gill has an excellent book on this
subject. More info can be found at http://www.projectvbabook.com.

As far as some starter code, you might want to take a look at a response
Rod gave to another poster in this newsgroup, "rate change on effective
date - print out", posted by Peggy Cornett on Sunday, June 24, 2007.

John
Project MVP

On Jun 25, 11:38 am, John <mjen...@theriver.com> wrote:
> In article <1182778160.139875.34...@q75g2000hsh.googlegroups.com>,
>
>
>
> arec...@gmail.com wrote:
> > 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!
>
> arectoo,
> First of all, what you want to do can certainly be automated with VBA,
> but it isn't necessarily straightforward. I wrote a macro some time ago
> for a client that does something very similar to what you want.
>
> However, since you are new to VBA, I suggest you consider getting a good
> book on Project VBA. Fellow MVP, Rod Gill has an excellent book on this
> subject. More info can be found at http://www.projectvbabook.com.
>
> As far as some starter code, you might want to take a look at a response
> Rod gave to another poster in this newsgroup, "rate change on effective
> date - print out", posted by Peggy Cornett on Sunday, June 24, 2007.
>
> John
> Project MVP

Hi John,

Thank you for the sample.

You'll be glad to know that I have just ordered that book on Amazon.
It can't come soon enough to help me with this problem...

RC